Hello there,
Can anyone explain to me to get Day from 'yyyy-mm-dd 00:00:00'
format.
Thanks in advance.
-Yamini
Getting Day from Date
Moderators: chulett, rschirm, roy
Do you just want the 'dd' portion? Are you sure the format will always be as you've indicated? Then substring it out:
Code: Select all
DateField[9,2]
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Getting Day from Date
yaminids wrote:Hello there,
Can anyone explain to me to get Day from 'yyyy-mm-dd 00:00:00'
format.
Code: Select all
DAYOFWEEK = oconv(iconv(EXTRACT_DATE_TO[7,4]:'-':EXTRACT_DATE_TO[4,2]:'-':EXTRACT_DATE_TO[1,2],"D-YMD[4,2,2]"),"DWA")