Re: getting the current date

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph>
Cc: PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: getting the current date
Date: 2002-10-17 07:26:50
Message-ID: 20021017072650.99605.qmail@web80303.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


--- Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph> wrote:
>
> how can i get the current date (without the time
> part) in sql.

--> try SELECT current_date();

ludwig.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joseph Syjuco 2002-10-17 09:11:44 getting the current date
Previous Message Tom Lane 2002-10-17 03:10:17 Re: replace null with 0 in subselect ?