Default dates

  • Thread starter Thread starter Steve S
  • Start date Start date
S

Steve S

There are various dates that are used as DEFAULT dates in the different
databases...... Is there a single method that will identify if the date
that comes back from a database is the DEFAULT date vs one that has been
entered ?

Example: DB2 uses 01/01/0001 as their default date.... FoxPro allowed a
blank date... which when retrieved by .NET comes back as 12/30/1899.....

Is there a method that we can use to determine if this is the default...
or a entered date ?
 
¤ There are various dates that are used as DEFAULT dates in the different
¤ databases...... Is there a single method that will identify if the date
¤ that comes back from a database is the DEFAULT date vs one that has been
¤ entered ?
¤
¤ Example: DB2 uses 01/01/0001 as their default date.... FoxPro allowed a
¤ blank date... which when retrieved by .NET comes back as 12/30/1899.....
¤
¤ Is there a method that we can use to determine if this is the default...
¤ or a entered date ?
¤

Probably not. You would probably need to write a stored procedure that returns an uninitialized date
parameter or calls a function, but it wouldn't be the same amongst all databases.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help! date showing as 1900/01/00 2
Excel How to get the number of days an item was opened from the today's date. 14
Default number format in Excel 1
DateTime Conversion 1
Form and default dates 9
Access Property sheet data missing also syntax 0
Default date format 4
Dates from DB2 displaying as 12:00:00 AM 3

Back
Top