Jump to content
Updating IPB tonight Read more... ×


This topic is now archived and is closed to further replies.


Null Time Variables

Recommended Posts

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?

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.