PleaseHelpPlease Posted May 31, 2005 Share Posted May 31, 2005 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.