dbTalk Databases Forums  

Get actual date and time in a ANSI SQL

comp.databases.postgresql comp.databases.postgresql


Discuss Get actual date and time in a ANSI SQL in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
davide
 
Posts: n/a

Default Get actual date and time in a ANSI SQL - 06-26-2007 , 09:32 AM






Hallo everybody,

I just have a little question, but very important for my applications, I
would want to know the exactly statement (or function) to get the
actualy date and time in ANSI SQL, I want use a very standard SQL.

thx

Reply With Quote
  #2  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Get actual date and time in a ANSI SQL - 06-26-2007 , 10:59 AM






davide <davide (AT) mail (DOT) it> wrote:
Quote:
I just have a little question, but very important for my applications, I
would want to know the exactly statement (or function) to get the
actualy date and time in ANSI SQL, I want use a very standard SQL.
CURRENT_TIMESTAMP without parentheses or
CURRENT_TIMESTAMP(precision) with integer argument

will return a timestamp with time zone.

If you want a timestamp without time zone, use LOCALTIMESTAMP instead.

Yours,
Laurenz Albe


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.