Re: [SQL] getting the current date

2002-10-17 Thread Ludwig Lim
--- Joseph Syjuco <[EMAIL PROTECTED]> wrote: > > how can i get the current date (without the time > part) in sql. --> try SELECT current_date(); ludwig. __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -

Re: [SQL] getting the current date

2002-10-16 Thread Bruce Momjian
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.p

[SQL] getting the current date

2002-10-16 Thread Joseph Syjuco
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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster