> uh, cf uses's something like "Excel_Time" or "DB2_Time", it's numeric
> time unit
> is *days* since 31-dec-1899 (it's epoch).
> uh, cf uses's something like "Excel_Time" or "DB2_Time", it's numeric
> time unit
> is *days* since 31-dec-1899 (it's epoch).
Right. I was talking about Unix's epoch (POSIX time) for date/time (as my
first apps were perl on linux), which is manipulated as such:
// get datetime int for storage
dat = DateDiff("s", "January 1 1970 00:00", Now());
// convert an int to whatever date/time format is required
LSdateformat(dateadd("s", dat, createdatetime(1970, 1, 1, 0, 0, 0)),"mmm dd yy")
LStimeformat(dateadd("s", dat, createdatetime(1970, 1, 1, 0, 0, 0)))
Works fine, and quite fast if you application cache the createdatetime. I've
simply liked to rely as little on proprietry database functions as possible.
Time to convert these to mysql DateTimes and use mysql's datetime functions
though I reckon. http://en.wikipedia.org/wiki/Unix_timestamp
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237850
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
