Archive

This post has been moved to mySharePointBlog. Go Here.

Category: SharePoint author: admin comments: Comments Off

Sample columns

date_col:

2007-05-06 00:00:00.000

time_col:

1971-01-01 01:06:23.000

Use this…

DATEADD(hh ,DATEPART(hh, [time_col]]), DATEADD(n ,DATEPART(n, [time_col]) , DATEADD(ss ,DATEPART(ss, [time_col]) , [date_col])))

To get this…

2007-05-06 01:06:23.000

Category: SQL author: admin comments: No Comments