Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 .
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
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.