February 25, 2008 at 10:17 am
I think your query is perfect.
Use this quesry in the data source command.
My Blog:
February 26, 2008 at 7:47 am
thkz a lot to everyone i made it atlast by all of ur help....but i got the date in Mar 13 2000 12:00AM format but i need to update it to 2000-03-13 00:00:00 format how can i do that plz let me know ....thkz in adavnce
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
February 26, 2008 at 7:49 am
Make sure that the datatype you are inserting into is of datetime and not varchar.
February 26, 2008 at 8:05 am
i have already imported the data so how can i jus make changes now thats what i want bcoz i have struggled to inser the data so i dnt want to try again i us want to make changes for the imported data by updating the date how can i do that
update table
set date=??/
what should i give to convert that date format to other
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply