SQL Server Performance

how to convert date filed in text file to system date

Discussion in 'SQL Server DTS-Related Questions' started by haridba, Aug 29, 2007.

  1. haridba New Member

    Hi I have a text file which has a date field, while loading this field i need to convert it into system date, how can i achieve this. Help on this is greatly appreciated. Thanks
  2. satya Moderator

    Why not use datetime data type for that column?
  3. FrankKalis Moderator

    How does the data look like?
    How do you load that data?
    What type of is your target column?
  4. Madhivanan Moderator

    [quote user="haridba"]
    Hi I have a text file which has a date field, while loading this field i need to convert it into system date, how can i achieve this. Help on this is greatly appreciated. Thanks
    [/quote]
    Upload data to table and then update
    update table
    set datecol=getdate()

Share This Page