OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: UTC timestamp

From: Zabach, Elke (elke.zabachsap.com)
Date: Fri Jul 04 2003 - 06:06:16 CDT


Christian Ullrich wrote:
>
> It is possible to specify DEFAULT TIMESTAMP for a column, but
> TIMESTAMP is local time. There is UTCDATE, which appears to be
> not only the current date at Greenwich, but a whole UTC time stamp.
> But SAPDB does not accept DEFAULT UTCDATE.
>
> I think this behaviour is nonsense. If I need timestamps in my
> records, I probably don't want local time, because the time zone is
> not stored with the value.
>
> Please allow DEFAULT UTCDATE specifications or an equivalent.

This is possible with kernel-version 7.4.4.2, not available as download so far,
available only when using CVS and private make.

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general