Database Administration

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