var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to set time in Postgresql database
There is one day difference in my OS date and time (2013-11-03) and
Postgresql database date and time (2013-11-04).
How can I change the date and time in Postgresql
using any SET command or something like that..
what is the use of this forum...!!!
No one is answering the question... even others questions...!!! ... just people are viewing only.... then what is the use of this...forum...
You mention a difference between OS / System time and Database time but how do you know the O.S. is wrong? Are you using NTP? What version of PostgreSQL? What O.S.?
If you're too lazy to post the information people need to help you, then people will be too lazy to respond to your problem...
carlos ~ $ date
carlos ~ $ psql -d postgres
Type "help" for help.
postgres=# SELECT current_date AS Date, current_time AS Time;
date | time
Wed Dec 11 22:22:08 UTC 2013
(1 row) 2013-12-11 | 22:22:12.867614+00