Home > mailing lists

getting the current date - Mailing list pgsql-sql

From	Joseph Syjuco
Subject	getting the current date
Date	October 17, 2002 00:11:52
Msg-id	1034845906.2085.1.camel@Falcon Whole thread Raw
Responses	Re: getting the current date Re: getting the current date
List	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

From: "Charles H. Woloszynski"
Date: 17 October 2002, 00:09:31
Subject: Re: Slow performance on MAX(primary_key)

From: Bruce Momjian
Date: 17 October 2002, 01:02:28
Subject: Re: getting the current date