Check for Invalid Dates

[login to unmask email]

Check for Invalid Dates
select
date (date_var) from sysibm.sysdummy1;

The table sysibm.sysdummy1 is a one row, one column table specifically
designed for such things (like date, time, timestamp verification);


Dean J. Burchill
248-576-8319
(8) 776-8319

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Peter Vanroose

Re: Check for Invalid Dates
(in response to DB46@DAIMLERCHRYSLER.COM)
> select
> date (date_var) from sysibm.sysdummy1;

On z/OS, from version 8 on, you may also write
values (date(date_var))
instead, as was already the case on version 7 for distributed platforms.

-- Peter.





_________________________________________________________
Flyger tiden iväg? Fånga dagen med Yahoo! Mails inbyggda
kalender. Dessutom 250 MB gratis, virusscanning och antispam. Få den på: http://se.mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm