Server-Side PDF Conversion with LibreOffice and IIS

|
| By Sahil Kumar

When building web applications on Windows servers using IIS, you may occasionally need to utilize locally installed desktop applications — like LibreOffice — for server-side tasks. A common example is converting Microsoft Word documents into PDF format. In this post,

CakePHP | How to change Epoch timestamp (unix timestamp) timezone in cakephp find query

| By Webner

Suppose we have a table cake_test with a column named modified that contains epoch values. CakePHP code: $options = array ( ‘fields’ => array ( “modified”, “to_timestamp(modified) as New__original”, “to_timestamp(modified) AT TIME ZONE ‘America/Denver’ as New__converted” ) ); $result =