What exactly is the difference between the different date types?
"2 Sep 2000"
CreateDate("2000", "9", "2") (outputs: {ts '2000-09-02 00:00:00'} )
CreateODBCDate(CreateDate("2000", "9", "2")) (outputs: {d '2000-09-02'} )
I tried inserting the result of these functions and they all work.
I tried inserting the actual string {ts '2000-09-02 00:00:00'} and it does NOT work,
so a date value is not just a string that represents a date.
I tried inserting the string "2 Sep 2000" and it works fine... so why do I need all
these date functions?
Note: I am not asking what DateFormat is good for, obviously it is good for formatting
human readable output. I am referring only to working with date variables and SQL.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
