SQL Editor
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:
Convert different string formats to datetime values.
If a conversion fails, return
NULL
.
Click here
for details on
string to datetime
.
SELECT TRY_CONVERT(datetime, '2022-11-01 05:29 PM', 0) AS 'mon dd yyyy hh:miAM/PM)', TRY_CONVERT(datetime, '2022-11-01 05:29 PM', 101) AS 'mm/dd/yyyy', TRY_CONVERT(datetime, '2022-11-01 05:29 PM', 3) AS 'dd/mm/yy', TRY_CONVERT(datetime, '2022-11-01 05:29 PM', 104) AS 'dd.mm.yyyy', TRY_CONVERT(datetime, '2022-11-01 05:29:01 PM', 8) AS 'hh:mi:ss', TRY_CONVERT(datetime, '2022-11-01 05:29 PM', 20) AS 'yyyy-mm-dd hh:mi:ss(24h)'
1 Record
mon dd yyyy hh:miAM/PM)
mm/dd/yyyy
dd/mm/yy
dd.mm.yyyy
hh:mi:ss
yyyy-mm-dd hh:mi:ss(24h)
11/1/2022 5:29:00 PM
11/1/2022 5:29:00 PM
NULL
1/11/2022 5:29:00 PM
NULL
11/1/2022 5:29:00 PM
About Us
Our Story
Customers
Contact Us
FAQs
Forum
Explore Forum
Login
Join
Products
Overview
Dofactory .NET
Dofactory SQL
Dofactory JS
Dofactory Bundle
Pricing
Product Pricing
Bundle Pricing
Compare Editions
Demos
Overview
Analytics App
Ecommerce App
SaaS App
CRM App
33-Day App Factory™
Tutorials
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
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms
Privacy
Licensing
EULA
Sitemap
© Data & Object Factory, LLC.
Made with
in Austin, Texas. Vsn 1.3.0