date format

[#1]

Hi,

i want year,month,week and hrs,second from following date format....

is it possible to get all this from following date format.

ex...

2013.01.08 01:15:20

[Gysbert_Wassenaar]

year(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))

month(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))

week(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))

hour(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))

minute(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))

second(timestamp#('2013.01.08 01:15:20',YYYY.DD.MM hh:mm:ss))

If your timestamp is already a numeric timestamp and not a string then you don't need the timestamp# function, but can use the year, month, ...etc functions directly on the field: year(MyTimeStampField) etc

[#3]

Hi,

I am using

year(('Date_Time')YYYY.DD.MM hh:mm:ss) as year

but i am getting error on above underline portion....

[#4]

hi,

i solved problem