Thursday, December 27, 2007

Convert Oracle Date to MS SQL Date

Oracle
_sqlQuery += ", to_date('" + DateFirstEnrolled + "', 'MM/DD/YYYY HH24:MI:SS')";

MS SQL
_sqlQuery += ", Cast('" + DateFirstEnrolled + "' as DateTime)";

No comments:

Check This Out!

More Links to Good Information