importing in date and time problems

• mark lake

  Say Hey Kid

  Points: 702

  More actions

  August 19, 2005 at 7:15 am

  #363470

  Hi,

   

  I'm currently importing a date field into SQL using the Enterprise Manager.

  The format is as follows:

  dd/mm/yyyy hh:mm:ss am

  But as soon as I've installed it into the SQL database it appears as:

   

  dd/mm/yyyy

  Completley losing the time details.  How can I do the import to correct this?  Any help would be greatly appreciated

   

  Cheers

   

  Mark

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 19, 2005 at 7:28 am

  #583509

  How are you inserting the data?

  Can you send the table definition and the code to insert in?

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  August 19, 2005 at 9:14 am

  #583569

  Might this be text?  You may need to do an explicit convert; CONVERT( datetime, 'dd/mm/yyyy hh:mm:ss am'). 

  Either way, this is a guess, and as Remi asked, it would be helpful to see your code and table definition. 

  I wasn't born stupid - I had to study.

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  August 19, 2005 at 9:28 am

  #583583

  what data type are you using in the table?

  and sometimes when using EM the dates show funny,

  use Query analyzer to validate your dates