Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923 Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 8:52 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:10 PM
Points: 98, Visits: 297
Have google a lot of different formats and I must be missing something.


How would one look to convert this format...?
2007-02-20 05:20:36.449923
Post #1378545
Posted Tuesday, October 30, 2012 2:17 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 3,917, Visits: 5,109
Convert it to what?

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1378606
Posted Tuesday, October 30, 2012 2:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
ya convert it to what ??
it looks like datetime2 ...


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1378611
Posted Tuesday, October 30, 2012 9:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:10 PM
Points: 98, Visits: 297
Convert to a date or date time
datetime2 ??? will look that up.
Post #1378841
Posted Wednesday, October 31, 2012 12:59 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 3,917, Visits: 5,109
In a DerivedColumn transaformation Editor, you would use, e.g.
(DT_DBTIMESTAMP2, 7)@[User::DateVar]



____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1379168
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse