datetime - Time Difference in PostgreSQL -


i need time 1 hour earlier current time in postgresql.

for example, if time 15:01:06, want result 14:01:06.

how can achieve in postgresql?

will work

select now()-interval '1 hour';


Comments

Popular posts from this blog

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

php - facebook and github login HWIOAuthBundle and FOSUserBundle in Symfony2.1 -

hadoop - Sqoop installation export and import from postgresql -