Popular Posts

  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • SSMS is Free
    SQLServerCentral » Latest topics SSMS is Free Comments posted to this topic are about the item [B] SSMS is Free [/B] more info... ...
  • The March of AI
    SQLServerCentral » Latest topics The March of AI Comments posted to this topic are about the item [B] The March of AI [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Wednesday, June 21, 2017

Expression needed for Midnight of previous day

SQLServerCentral » Latest topics
Expression needed for Midnight of previous day
How to get expression for yesterday and day before so that the time stamp resets *exactly to midnight*?

I have 
Yesterday gives 6/18/2017 10:04:10 AM  *need 6/18/2017 12:00:00 AM*
@[User::ToDate] = (DT_DATE) DATEADD("DAY",-
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)