AZR-SQL101

select format(GETDATE(),'dddd - dd - MMMM - yyyy','nl-NL') --> dinsdag - 11 - september - 2018 select format(GETDATE(),'ddd - dd - MMM - yyyy','nl-NL') --> di - 11 - sep - 2018 select format(GETDATE(),'dddd - dd - MMMM - yyyy','de-DE') --> Dienstag - 11 - September - 2018 select format(GETDATE(),'ddd - dd - MMM - yyyy','de-DE') --> Di - 11 - Sep - 2018 select format(GETDATE(),'dddd - dd - MMMM - yyyy','en-US') --> Tuesday - 11 - September - 2018 select format(GETDATE(),'ddd - dd - MMM - yyyy','en-US') --> Tue - 11 - Sep - 2018 Till Next Time

select name,        create_date,        modify_date from   sys.views order by modify_date desc Till Next Time