Date format
Posted: Mon Sep 10, 2007 5:02 am
Hi All,
I used below code to populate in one of my target field as below format.
CCCC-MM-DD HH:MM:SS.
code is:
TimestampToString(StringToTimestamp(from_funnel.EFCTE_CLCLD_DTTM, "%yyyy%mm%dd %hh:%nn"), "%yyyy-%mm-%dd %hh:%nn:%ss")
but now my requirement is to poulate only 'CCCC-MM-DD' format,but not needed time.
where can i modify my code in my previous code.
Help should be appreciated.
I used below code to populate in one of my target field as below format.
CCCC-MM-DD HH:MM:SS.
code is:
TimestampToString(StringToTimestamp(from_funnel.EFCTE_CLCLD_DTTM, "%yyyy%mm%dd %hh:%nn"), "%yyyy-%mm-%dd %hh:%nn:%ss")
but now my requirement is to poulate only 'CCCC-MM-DD' format,but not needed time.
where can i modify my code in my previous code.
Help should be appreciated.