Post reply

regd date small issue

  • February 25, 2008 at 10:17 am

    #781653

    I think your query is perfect.

    Use this quesry in the data source command.




    My Blog: http://dineshasanka.spaces.live.com/

  • February 26, 2008 at 7:47 am

    #781993

    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

    #781999

    Make sure that the datatype you are inserting into is of datetime and not varchar.

  • February 26, 2008 at 8:05 am

    #782011

    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