Hi,
Take a look at date_part() function . it is useful to extract any part(
day,dow,month, year, ...) from a datetime variable.you may use now()
function to catch the current system datetime.
Also there is an internal search ingine on postgresql.org site, which may be
used as a useful search tool inside the docs.
regards
omid.
>From: "sheila bel" <sheilabel@hotmail.com>
>To: pgsql-general@postgreSQL.org
>Subject: [GENERAL] CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
>Date: Tue, 29 Feb 2000 00:51:46 GMT
>
>Hi all,
>
>I wanted to get some information about date and time
>stamps and examples of how to use them. In the User
>Manual I got referred to functions called CURRENT_DATE,
>CURRENT_TIME. I have been literally searching for
>hours to find more about them in all the PostgreSQL
>manuals, I've used ALL the search engines and did not
>find anything. If there is a reference to them they should
>be somewhere in there, right?
>I'm sorry but dear developers your manual is not user
>friendly at all :(
>A lot of time gets wasted on finding the information you
>need or not finding them at all.
>
>-Sheila
>
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>
>************
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
