logo       

null value in date field: msg#00241

db.postgresql.novice

Subject: null value in date field

I have a form that contains optional DATE fields. To enter null values, I've tried null, 'null', '', '-', '0', 0, and each time I get one of the following errors:

ERROR: Bad numeric input format ''

ERROR: Bad date external representation ''

Is there a correct way to enter null values into DATE fields?

Thanks,
Jeff Deroshia


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise