Monday, February 25, 2013
postgres date and time query
Postgres saves times in UTC to do a query using the server timezone use the below
select caller_aor,callee_aor,start_time AT TIME ZONE 'UTC' from cdrs where and start_time > '2013-02-22 00:00:00' AT TIME ZONE 'UTC';
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment