You might try SELECTing the date column and see what it returns.
You might also ask the DBA what the date datatype is.
I know, from sad experience, that DB2 DBA's tended to use non-date
datatypes because they are somewhat new in the last decade.
We have DB2 on our AS400 and NO ONE uses a date/time datatype. Instead,
we have a mix of char- and numeric-based datatypes.
For example, we may have dates stored as: 20051031 or '20051031'.
What you want is to see an output like: {2005-10-31 15:31:59.000}
Or something similar to that. If you do see that format, then you have
a good date/time datatype. These date/time values are pretty standard
and most languages can parse them correctly.
If you have a "canonical" format like 20051031, then you will need to
manually parse it before using any of CF's date/time functions, if
desired.
M!ke
-----Original Message-----
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 5:41 PM
To: CF-Talk
Subject: RE: OT - Complex SQL
You're so right... Anybody happen to now offhand (I'm off to search
after I send this message) what the date format is for DB2?
I'm just running this at the command line, so no need for any CF
stuffs... But unfortuantely also can't take advantage of CF stuffs.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222636
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
