world wide web development problems asp net php html xhtml css javascript jquery w3dproblems
Friday, December 5, 2014
How to combine date from one field with time from another field - MS SQL Server
SELECTCAST(MyDate ASDATETIME)+CAST(MyTime ASDATETIME)AS CombinedDateTime
--OR--if date part is missing and you want to format time in asp netSELECTCAST(GETDATE()ASDATE)+CAST(MyTime ASDATETIME)AS CombinedDateTime
No comments:
Post a Comment