| | |
|---|
| | | // | Author: Paul Cooper <pgc@ucecom.com> |
|
|---|
| | | // +----------------------------------------------------------------------+
|
|---|
| | | //
|
|---|
| | | // $Id: pgsql.php,v 1.10 2008/02/17 18:54:08 quipo Exp $
|
|---|
| | | // $Id: pgsql.php 268669 2008-11-09 19:46:50Z quipo $ |
|---|
| | |
|
|---|
| | | require_once 'MDB2/Driver/Function/Common.php';
|
|---|
| | |
|
|---|
| | |
|---|
| | | */
|
|---|
| | | function unixtimestamp($expression)
|
|---|
| | | {
|
|---|
| | | return 'EXTRACT(EPOCH FROM DATE_TRUNC(\'seconds\', TIMESTAMP '. $expression.'))';
|
|---|
| | | return 'EXTRACT(EPOCH FROM DATE_TRUNC(\'seconds\', CAST ((' . $expression . ') AS TIMESTAMP)))'; |
|---|
| | | }
|
|---|
| | |
|
|---|
| | | // }}}
|
|---|
