Joseph Syjuco wrote:
>
> 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
test=> SELECT CURRENT_DATE; date
------------2002-10-17
(1 row)
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
