Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Datetime format

In my Load script,

(Modified_Date, 'YYYY-MM-DD hh:mm:ss') as Modified_Date 

gets me the value            2014-08-12 16:03:31

but I need                          2014-08-12 16:03:31.643

I would appreciate help...

Thanks

Tags (2)
1 Solution

Accepted Solutions

Re: Datetime format

Original field is a datetime/timestamp: date(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date

Original field is a text value: tetime/timestamp: date#(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date


talk is cheap, supply exceeds demand
2 Replies

Re: Datetime format

Original field is a datetime/timestamp: date(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date

Original field is a text value: tetime/timestamp: date#(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date


talk is cheap, supply exceeds demand

Re: Datetime format

Hi,

try with Timestamp() and Timestamp#()

Like,

Timestamp(DateField, 'YYYY-MM-DD hh:mm:ss.fff')


Regards

Regards,
Prashant Sangle
Community Browser