Richard Douglas

Richard Douglas is a SQL Server Professional working in the UK where he recently worked as a DBA in women's clothing, not literally he hastens to add! He is certified in SQL Server 2008, runs the Maidenhead SQL Server User Group Pass Chapter and is on the organising committee for SQL Relay. In his spare time plays the trumpet in local symphony orchestras.



His online presence includes:
  • Interests: Usual stuff: family, SQL Server, shiny things.

All authors

All authors

Blogs

How-To Convert Excel Date & Time to SQL

By

Hey data friends! This one comes from my personal vault (aka backlog of drafts...

SQL in 2025: Still the King of Data

By

Data's the new oil, and SQL is your refinery. It's still the go-to language...

Drop roles in Postgres

By

You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide

By Arvind Toorpu

Comments posted to this topic are about the item Creating a Linked Server in...

Dates and Languages

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Dates and Languages

Visit the forum

Question of the Day

Dates and Languages

The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned? 

DECLARE @yourInputDate  NVARCHAR(32) = '28 listopad 2018';

SET LANGUAGE Polish;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish];

SET LANGUAGE Croatian;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian];

SET LANGUAGE English;

See possible answers