YYYY-MM-DD HH:MM:SS
behaves as expected on queries
no manipulation necessary
you can set a validation mask
CREATE TABLE [tEnforceTimestamp2] (
[cTimestamp] TEXT CHECK (cTimestamp LIKE'____-__-__ __:__:__')
)
or
CREATE TABLE [tEnforceTimestamp2] (
[cTimestamp] TEXT CHECK(cTimestamp > '1900-01-01' AND cTimestamp <
'2099-01-01' AND cTimestamp LIKE'____-__-__ __:__:__')
)
and
you know what it is when you see it.
SD
[EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
