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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment