Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to parse string into date?

Tags:

tsql

sql-server-2005

How can I convert a String to a Date in T-SQL?

My test case is the string: '24.04.2012'

like image 632
Nazar Tereshkovych Avatar asked Apr 24 '12 19:04

Nazar Tereshkovych

People also ask

Can we convert string to date in java?

By default, Java dates are in the ISO-8601 format, so if we have any string which represents a date and time in this format, then we can use the parse() API of these classes directly.

1 Answers

CONVERT(datetime, '24.04.2012', 104)

Should do the trick. See here for more info: CAST and CONVERT (Transact-SQL)

like image 85
Chris Roberts Avatar answered Oct 03 '22 09:10

Chris Roberts
Sign in to Comment

Related questions

Command for adding a default constraint
SQL Server 2008 Empty String vs. Space
Does T-SQL have an aggregate function to concatenate strings? [duplicate]
Combine multiple results in a subquery into a single comma-separated value
Convert a SQL Server datetime to a shorter date format
Boolean 'NOT' in T-SQL not working on 'bit' datatype?
Why use Select Top 100 Percent?
SQL Views - no variables?
Generate SQL Create Scripts for existing tables with Query
How do you update a DateTime field in T-SQL?
Do clustered indexes have to be unique?
How to compare datetime with only date in SQL Server
Understanding SQL Server LOCKS on SELECT queries
How to view the stored procedure code in SQL Server Management Studio
How to insert default values in SQL table?
TSQL: How to convert local time to UTC? (SQL Server 2008)
T-SQL loop over query results
Get the records of last month in SQL server
Understanding PIVOT function in T-SQL
Simple DateTime sql query

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!