regarding the date conversion
Moderators: chulett, rschirm, roy
regarding the date conversion
I am using server edition,I have to populate in my target enddate column as "2045/11/08" i enddate column datatype is timestamp i am tried aboveformat and "2045/11/08 00:01:00" but it is showing only year "2045/00/00" how can i populate the whole thing
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
Iconv and Oconv can be used for converting dates. You can use something like
Use the Search facility for Iconv & Oconv, You can find N number of posts.
Thanks
DS_SUPPORT
Code: Select all
Oconv(Iconv(InputColumn,"D/DMY[2,2,4]"),"D-YMD[4,2,2]") : ' 00:00:00'
Thanks
DS_SUPPORT
-
- Participant
- Posts: 9
- Joined: Tue Jul 26, 2005 11:12 pm
- Location: Bangalore
Re: regarding the date conversion
Hi
You can concatenate the date with "00:00:00.000". it will be converted to time stamp.
You can concatenate the date with "00:00:00.000". it will be converted to time stamp.
Regards,
Kiran
Kiran
No, that just adds a zero time to a given date but doesn't automagically make it a 'timestamp'. Plus you may (or in this case not) need the milliseconds you've added on.
A timestamp is a date/time in a specific format, usually ISO like so:
YYYY-MM-DD HH24:MI:SS
So there's typically more than just sticking zeroes on the end.
A timestamp is a date/time in a specific format, usually ISO like so:
YYYY-MM-DD HH24:MI:SS
So there's typically more than just sticking zeroes on the end.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers