Postgres Pro
Downloads
Home   >   mailing lists

Re: getting the current date - Mailing list pgsql-sql

From Ludwig Lim
Subject Re: getting the current date
Date
Msg-id 20021017072650.99605.qmail@web80303.mail.yahoo.com
Whole thread Raw
In response to getting the current date  (Joseph Syjuco <joseph@asti.dost.gov.ph>)
List pgsql-sql
Tree view 
--- Joseph Syjuco <joseph@asti.dost.gov.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: replace null with 0 in subselect ?
Next
From: Richard Huxton
Date:
Subject: Re: Slow performance on MAX(primary_key)