August 8, 2006 at 4:25 am
Hello,
I am facing problems in converting timestamps to date. I have tried using DT_DBDate and still unsuccessful.
Iam trying to use a lookup based on timestamp which needs to be converdted to date before comparing
example
Activation date in to look up:2006-01-01 00:09:08.000
This needs to be compared with 2006-01-01 00:00:00.000
Please help to make a date comaprison. Iam unable to use convert as well.
August 8, 2006 at 8:10 am
obviously, you'll need to change the getdate() to your datetime column
August 8, 2006 at 8:10 am
Can you use this in the lookup to change the value you lookup against:
select dateadd(dd,datediff(dd,0,getdate()),0)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply