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:
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 value in a date field. If a try a sql
> s