Full date to midnight
Posted on 2006-11-01
Im pulling the date from a sql database it has the date and time I want to keep the date and make the time 00:00:00.000 AM
here it is in SQL i need it converted to vb.net, x.item(4) is the date from the database
I'm trying to get the minutes itno the day.
datediff(minute, CAST(CONVERT(varchar(10), DATEADD(dd, 0, x.Item(4)), 101) + ' 00:00:00.000 AM' AS DATETIME), x.Item(4))