Home Forums SQL Server 2005 T-SQL (SS2K5) Help with datetime column RE: Help with datetime column

  • January 26, 2009 at 8:07 am

    #932606

    Does this give you what you want?

    select cast(convert(varchar(10),getdate(),101)+' 02:00AM' as DateTime)