getting the current date

From: Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph>
To: pgsql-sql(at)postgresql(dot)org
Subject: getting the current date
Date: 2002-10-17 09:11:44
Message-ID: 1034845906.2085.1.camel@Falcon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


how can i get the current date (without the time part) in sql. I tried
doing a select now() but it also gives me the time part
TIA
joseph

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2002-10-17 09:26:52 Re: Slow performance on MAX(primary_key)
Previous Message Ludwig Lim 2002-10-17 07:26:50 Re: getting the current date