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
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
