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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073