Also:

A date is represented in DBF as "YYYYMMDD"
Wil timestamp be represented in DBFS with 17 characters ?
eg: YYYYMMDDHHMMSSmmm bieng the last 3 millisecs.

Another one:
Why timestand has to have a literal representation since dates don't have it
?

In dates we use dtos(), stod(), dtoc() ctod()
So in timestanp we should use ttos(), stot(), ttoc(), ttoc() don´t we ?

Regards
Angel



Chen Kedem wrote:
> 
>> The main problem we have now is syntax which we should use for
>> constant representation of timestamp (date + time) values in .prg code.
> 
> Just to add to the general mayhem, ODBC and MSSQL understand this FIXED
> notation:
> 
> Date:
> {d 'yyyy-mm-dd'}
> 
> DateTime (timestamp):
> {ts 'yyyy-mm-dd hh:mm:ss'}
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Date-Time-Functions---Revisited-%28II%29-tp21926105p21979336.html
Sent from the Harbour - Dev mailing list archive at Nabble.com.

_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour

Reply via email to