A date is always stored as scaliger no (numeric value - representing the number of days since 01/01/4713 BC).
SQL is able to translate any character string in one of the following formats into a real date: YYYY-MM-DD, DD.MM.YYYY, MM/DD/YYYY.
Date formats are only used for making this scaliger no readable.
The (current) date format to be can be changed in your environment.
Even though a current date format with a 2 digit year is used and the maximum value of a date cannot be displayed, the maximum date can be inserted correctly into date fields (without any error).

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"

-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Jeff Young
Gesendet: Tuesday, 22.12 2015 21:41
An: Midrange Systems Technical Discussion
Betreff: Re: Default date in SQL

Isn't that beyond the maximum year for a DATE field?

Jeff Young
Sr. Programmer Analyst

On Tue, Dec 22, 2015 at 3:25 PM, Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>
wrote:

DEFAULT '9999-12-31' ?

On Tue, Dec 22, 2015 at 3:16 PM, Raul A Jager W <raul@xxxxxxxxxx> wrote:

I want to create a table with a date field that has "maxvalue" as
default, but SQL rejects it.
I think it is because that is not a date, is there a way to define
the max date?

TIA,
Raúl

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.




--


Jeff Crosby
VP Information Systems
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
www.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of
my company. Unless I say so.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].