Re: [SQL] problem with date/time constants

Hi, 'now' is a function... so try 'select now();' On Tue, 3 Jul 2001, datactrl wrote: > Hi, > server:PostgreSQl 7.1 > why doesn't following statement work? > "select now;" > > THANK YOU! > JACK LIU > > > > ---(end of broadcast)--- > TIP 6:

[SQL] problem with date/time constants

Hi, server:PostgreSQl 7.1 why doesn't following statement work? "select now;" THANK YOU! JACK LIU ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [SQL] problem with date

Try NULL rather than ''. '' is not a null in postgres. - Original Message - From: Shalini shikha <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 10, 2000 3:15 PM Subject: [SQL] problem with date > How can I insert/update a null va

[SQL] problem with date

How can I insert/update a null value in a date field. If a try a sql statement like the following: update customer set birth_date = '' where cust_id like 'xyz', I get a error message saying: Bad date representation. Thanks in advance, Shalini