TimeStamp Variable.

[karry450]

hi friends,

I am using @DATE as system variable at the moment to get the date as my output .

Is there any system variable to get date+timestamp as output.

Thanks &Regards
Karthik

[ArndW]

No, you need to concatentate the system variables @DATE and @TIME, i.e.

Code: Select all

OCONV(@DATE,'D4/E'):' ':OCONV(@TIME,'MTS')

[ray.wurlod]

System variables give the job start, which timestamp can also be had via the DSJobStartTimestamp macro. If you need the timestamp "now", prefer Date() and Time() functions.

Code: Select all

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

[karry450]

Hi Friends,

Thanks for your reply. but still having a problem with date conversion.

No, you need to concatentate the system variables @DATE and @TIME, i.e.

Code: Select all

OCONV(@DATE,'D4/E'):' ':OCONV(@TIME,'MTS')

...

can you please let me know what is D4/E meant?

Thanks & Regards
Karthik Chandra

[ArndW]

Karry450 - it is in the documentation for the OCONV function. Date, 4 digits for the year with a "/" as separator and European format.

[karry450]

Karry450 - it is in the documentation for the OCONV function. Date, 4 digits for the year with a "/" as separator and European format. ...

But when I try this function im getting in the format of MM/DD/YYYY hh:mm:ss but is there any way to convert it to DD/MM/YYYY hh:mm:ss


Thanks
karthik

[ArndW]

karry450 - The format for that would be "D4/DMY[2,2,4]"