Date format conversion problem

[#1]

Hello Team members,

I have the date field  in the format  '10/20/2013 23:34:00', now I want to convert the above date field into only date format without any time like '10/20/2013'

can anyone help me please.

Regards,

Ramesh

[#2]

Hi,

     To get only the Date Format , try the below code

Date('10/20/2013 23:34:00'  , 'MM/DD/YYYY') 

Please let me know if there is anything .

[Anonymous]

Ramesh,

If you don't need the time part, it is always a good idea to remove it in the script:

date(floor(<your timestamp field>), 'MM/DD/YYYY') as Date.

You'll save some memory this way, expecially if you have a lot of values in this field.

Regards,

Michael

[Anonymous]

Hi,

Use this Timestamp(timestamp#('10/20/2013 23:34:00','MM/DD/YYYY hh:mm:SS') , 'MM/DD/YYYY') i think its helpfull for you.

Thanks & Regards,

Chandini.