Here is a list of the different date formats that come standard in SQL Server as part of the CONVERT function. Tweet Tweet
If you would like to find out a Database restore, source and backup date you will need to execute the below script: SELECT [rs].[destination_database_name], [rs].[restore_date],……
FormatDateTime command Command Result FormatDateTime(Parameters!Date.Value,1) Tuesday, February 10, 2011 FormatDateTime(Parameters!Date.Value,2) 2/10/2007 FormatDateTime(Parameters!Date.Value,3) 12:00:00 AM FormatDateTime(Parameters!Date.Value,4) 00:00 Format command Command Result Format(Parameters!Date.Value,”dd-MM-yyyy”) 10-02-2011 Format(Parameters!Date.Value,”dd/MM/yyyy”) 10/02/2011 Format(Parameters!Date.Value,”MMM-dd-yyyy”) Feb-10-2011 Format(Parameters!Date.Value,”MMM-dd-yy”) Feb-10-11 Format(Parameters!Date.Value,”MMMM-dd-yy”) February-10-11 Format(Parameters!Date.Value,”MMMM dd yyyy”) February 10 2011 Also this expression: =Day(Parameters!AsOfDate.Value) & “/” & Month(Parameters!AsOfDate.Value) & “/” & Year(Parameters!AsOfDate.Value)……