How to fetch date,time,hour,sec From Timestamp?

[ysj]

Hi,

I have differents log files contains timestampas field.in that field I am getting below value.

But I am trying to fetch values date,time,hour,min,sec

Also  I have chagned my mai script as below;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='₹ #,##0.00;₹ -#,##0.00';

SET TimeFormat='hh:mm:ss';

//SET DateFormat='YYYY-MM-DD';

//SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-IN';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Please provide your thoughts.

[ysj]

Thank you Antonio.

As I am using QV12 and my server is also QV12 then what should I do for time format.

As I have log files in text format having timestamp filed containing mention values.

then what should I do .

[ysj]

Thank you so much Ruben,

As I am using QV12 and my server is also QV12 then what should I do for time format

But this values are comes from server itself then which value is correct either added + 4hours or as it is?

[antoniotiman]

Hi,

You can use expressions like my attachment below.

It works also in QV12.