| Author |
default date?
|
Jennifer Sohl
Ranch Hand
Joined: Feb 28, 2001
Posts: 455
|
|
Hi. I've noticed that when you declare a column of the datetime datatype in SQL it puts in a default value of 1900-01-01 00:00:00.000 Is there a simple way that I can check and see if the date is this value and if so, not display it in my text field? Is there something like an 'isDefault(boolean)' method that I can use to determine that, or is it more complicated than that? Thanks for any help!
|
 |
Dave Vick
Ranch Hand
Joined: May 10, 2001
Posts: 3244
|
|
Jennifer I don't know about a test for default but could you make the column so it accepts null and then specify null as the default, then you'd only have to test for null??...
|
Dave
|
 |
Jennifer Sohl
Ranch Hand
Joined: Feb 28, 2001
Posts: 455
|
|
That's what I thought. Just thought I'd double check and make sure I wasn't missing something. Thanks for the help!
|
 |
 |
|
|
subject: default date?
|
|
|