Jump to content


Photo

Null Time Variables


  • Please log in to reply
No replies to this topic

#1 PleaseHelpPlease

PleaseHelpPlease
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 31 May 2005 - 10:29 PM

We have a time variable in the database, its default is set to NULL. When we perform an update, the value it will get assigned to is dependent on a variable. This variable is either a time in the format HH:MM:SS, or just a blank string. We have no problem updating when its in the time format, however when its a blank string, we want the value in the DB to be updated to NULL. Instead however it becomes 00:00:00. Any suggestions?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users