File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes default date? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "default date?" Watch "default date?" New topic

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
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??...

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!
I agree. Here's the link:
subject: default date?
It's not a secret anymore!