Current Timestamp

[kab123]

Hi All,

I have to create a new column and have to give the current timestamp for that. what expression/Derivation I need to give with that.
Database is SYBASE.

Thanks in advance .
abhi

[ray.wurlod]

Current timestamp in ISO8601 format is given by

Code: Select all

Oconv(Date(), "D-YMD[4,2,2]"):" ":Oconv(Time(), "MTS:")

Substitute system variables @DATE and @TIME for Date() and Time() if you want "current timestamp" as at the start time for the job, instead of as at "now".

Sybase OC expects YYYYMMDD HH:MM:SS.sss as the format. If you don't need milliseconds use

Code: Select all

Oconv(Date(), "D-YMD[4,2,2]":@VM:"MCN"):" ":Oconv(Time(), "MTS:"):".000"

If you do need milliseconds, you will need to create a Routine, in which you enabled $OPTIONS TIME.MILLISECOND and then use SYSTEM(12) to obtain the number of milliseconds since midnight. And that's assuming your operating system can deliver clock milliseconds.

[kab123]

Thanks Ray

Abhi