Change datetime format from Tasks > Generate Scripts

• oralinque

  Ten Centuries

  Points: 1157

  More actions

  July 6, 2010 at 2:07 pm

  #223612

  I love the ability to script actual data in tables in SQL Server 2008, however, the output of the datetime columns is a hassle if I need to insert the records into an Oracle database. For example, the date/time '2010-02-02 00:00:00.000' is represented as CAST(0x00009D1100000000 AS DateTime). This works great for SQL Server databases, but will not work for Oracle. Is there a way to change it so that it generates a human readable date?

• Nicholas Rowan-483335

  SSC Rookie

  Points: 35

  More actions

  March 15, 2011 at 4:50 am

  #1298751

  I'm actually struggling with the same issue. If I find anything I'll post it here. If you manage to come right let me know! 🙂