PostgreSQL — полезные функции

Перевод дат в timestamp формат

[cc lang=’sql’]

cast(EXTRACT( epoch FROM  cdate) as int8) as timestamp

cast(EXTRACT( epoch FROM  cdate) as int4) as timestamp

[/cc]

Leave a Reply