setting smalldatetime column to NULL

[varocho]

Using: System 11

A co-worker is trying to get her PERL script to UPDATE a record so a smalldatetime column is set to NULL, but not having any luck. Apparently a statement like

UPDATE table
SET smalldatetimeColumn = NULL
WHERE ...

doesn't work though it works fine in SQL Advantage. Is there any way to get the above statement to work in PERL? Is there some Sybase function to set a value to NULL?

 

[qyllr]

hello,

how are you connecting to the database? are you using sybperl, dbi, or a sql block in perl?

q.

 

[varocho]

q,

Thanks for responding. My co-worker fixed the problem she was having (she just needed to check for a 1/1/1900 date being set in a form variable so this would end up being replaced with a NULL value).