Tuesday, September 7, 2010

OLE Date/Time

http://www.newobjects.com/pages/ndl/SQLite2\SQL-OleDate.htm

Related to SQL.

Starts from 30 December 1899 00:00:00


It would seem that the newer, OLD DB Date/Time, SQL Server 2008 R2, support milliseconds.

'yyyy-mm-dd hh:mm:ss[.999]

The time structure is has greater resolution:

'hh:mm:ss[.9999999]


No comments: