This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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

Win a copy of Building Microservices this week in the Design forum!
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: default date?
It's not a secret anymore!