Hi,

ok, thanks, i hoped that there is a way to have the timestamp column
altered implicitely on select oder update query without having this to
be written expliclit in the query.

Thanky,

Mitko

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Daniel
Dittmar
Sent: Sunday, February 02, 2003 8:12 PM
To: [EMAIL PROTECTED]
Subject: Re: Questions about TIMESTAMP


Mitko R�rup wrote:
> I'm just loking for an method to create an culumn which modifies an 
> Timestamp to teh actual time, on writes but even on readouts. If 
> automatic in read not possible an modified timestamp on write access 
> is enougth. Is there is an way to manage this in SapDB?

You're searching for the TIMESTAMP function:
http://www.sapdb.org/htmhelp/15/1a2bb4b44d11d2a97100a0c9449261/frameset.
htm

This is an ordinary expression that can be assigned to columns (in 
INSERT or UPDATE) or that can be used as a select column (e.g. SELECT 
TIMESTAMP from DUAL).

Daniel Dittmar

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to