Time Stores hour, minute and second info Seconds since 1/1/1970This is where I get totally confused. I tried to enter some time values 00:00, 24:00 and 48:00. Then I wanted to run a query SELECT "Time", Cast("Time" AS DATE) AS "Date_Cast" FROM "Times" in order to see if the dates are 1970-01-01, 1970-01-02 and 1970-01-03 BUT: I can not enter times >=24:00 (truncated to hours 0-23) and cast() can not convert times to dates. So what is the meaning of "Seconds since 1/1/1970"?Right again - clear as mud isn't it.
Actually it is clear - it is clearly wrong. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
