SQL Editor
SQL Format Culture Example
Tables and Columns
Customer
- Id
(int)
- FirstName
(nvarchar)
- LastName
(nvarchar)
- City
(nvarchar)
- Country
(nvarchar)
- Phone
(nvarchar)
Order
- Id
(int)
- OrderDate
(datetime)
- OrderNumber
(nvarchar)
- CustomerId
(int)
- TotalAmount
(decimal)
OrderItem
- Id
(int)
- OrderId
(int)
- ProductId
(int)
- UnitPrice
(decimal)
- Quantity
(int)
Product
- Id
(int)
- ProductName
(nvarchar)
- SupplierId
(int)
- UnitPrice
(decimal)
- Package
(nvarchar)
- IsDiscontinued
(bit)
Supplier
- Id
(int)
- CompanyName
(nvarchar)
- ContactName
(nvarchar)
- ContactTitle
(nvarchar)
- City
(nvarchar)
- Country
(nvarchar)
- Phone
(nvarchar)
- Fax
(nvarchar)
Task:
Format the current date for different cultures.
Click here
for details on
Format
.
SELECT FORMAT(GETDATE(), 'd', 'en-US') AS 'US', FORMAT(GETDATE(), 'd', 'en-gb') AS 'GB', FORMAT(GETDATE(), 'd', 'de-de') AS 'Germany', FORMAT(GETDATE(), 'd', 'zh-cn') AS 'China)', FORMAT(GETDATE(), 'd', 'hi-IN') AS 'India', FORMAT(GETDATE(), 'd', 'ru-RU') AS 'Russia', FORMAT(GETDATE(), 'd', 'gl-ES') AS 'Galicia (Spain)'
1 Record
US
GB
Germany
China)
India
Russia
Galicia (Spain)
3/20/2025
20/03/2025
20.03.2025
2025/3/20
20-03-2025
20.03.2025
20/03/2025
About Us
Our Story
Customers
Contact Us
FAQs
Forum
Login
Sign up
Sitemap
Pricing
Product Pricing
Bundle Pricing
Compare Editions
Jobs
Find Jobs
Jobs by Technology
Jobs by Role
Jobs by Location
Jobs by Company
Post a free Job
Companies
Find Companies
Companies by Technology
Companies by Location
List your Company
Products
Overview
Dofactory .NET
Dofactory SQL
Dofactory JS
Dofactory Bundle
Demos
Overview
Analytics App
Ecommerce App
SaaS App
CRM App
33-Day App Factory™
Learning
Overview
SQL Tutorial
SQL Reference
HTML Tutorial
HTML Reference
.NET Design Patterns
C# Coding Standards
JavaScript Tutorial
Connection Strings
Visual Studio Shortcuts
C# Code Examples
Articles
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms
Privacy
Cookies
Do Not Sell
Licensing
Made with
in Austin, Texas.
- vsn 44.0.0
© Data & Object Factory, LLC.
in Austin, Texas. - vsn 44.0.0