try use PARSE t-sql function
SELECT PARSE(timestamp AS date USING 'Ru-RU') from table
Top answer 1 of 4
4
try use PARSE t-sql function
SELECT PARSE(timestamp AS date USING 'Ru-RU') from table
2 of 4
1
SQL Server is actually pretty flexible on converting date/times without a format. So, if you want to convert to a date/time, this works:
select convert(datetime, '06.07.2021 00:00:00')
If you are only looking at the date, though, you might want to limit to the first 10 characters. If you are certain that all the strings have valid dates, you can use 104 to convert the value:
select cast(date, left(datetime, 10), 104)
W3Schools
w3schools.com › sql › func_sqlserver_convert.asp
SQL Server CONVERT() Function
String Functions: ASCII CHAR_LENGTH ... STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK Advanced Functions: BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION SQL Server Functions · String Functions: ...
sql server convert date to string MM/DD/YYYY - Stack Overflow
I am using SQL Server 2008. I have the following: select convert(varchar(20),fmdate) from Sery How do I convert the date to string such that it show as MM/DD/YYYY More on stackoverflow.com
How do I format a date or convert a date to a specific string?
the default format for the dates in my database is MM/DD/YYYY (01/02/2021) Except it isn't. All date & time data types in SQL Server are stored as binary data, not as strings. They have no "format" - formatting is done by the client application (yes, even SSMS). When you enter a date like 01/02/2021 in an application, the application or SQL Server is making a guess about what you mean based on regional settings and possibly other factors. Unless you're storing your dates as strings. If you're doing that, we gotta have a chat. But like u/IHeartBadCode said, you really need a date table to do this kind of lookup/translation, not code embedded in a query. More on reddit.com
6
4
June 23, 2021Convert Text to Date DataType – SQLServerCentral Forums
I need this because i am using ... to be in Date DT. ... SSC Eights! ... yes i can do that but,how will sql know that my text is in dd/mm/yyyy format and not in mm/dd/yyyy or smthing else. ... yes i can do that but,how will sql know that my text is in dd/mm/yyyy for and not in mm/dd/yyyy or smthing else. ... The third value in the convert statement tells SQL Server the string value of the ... More on sqlservercentral.com
sql server - How to convert a datetime to string in T-SQL - Stack Overflow
I think you're actually working too hard here. SQL Server has implicit string equivalents for DATETIME2. What you're actually doing here is utilizing the implicit conversion and then formatting the resulting string, not the datetime. 2019-01-23T20:19:20.18Z+00:00 ... @JamieMarshall more or less. MSDN suggests: Use the FORMAT function for locale-aware formatting of date/time and number values as strings. For general data type conversions, use CAST or CONVERT... More on stackoverflow.com
Videos
09:30
Convert numbers and dates into strings in SQL Server using the ...
04:18
Convert Datetime into String | Datetime to String conversion in ...
How to Correctly Convert String to Date in SQL
01:18
How to Convert a VARCHAR Date String to DATETIME in SQL ...
12:15
Converting a String to Date in SQL | CAST | CONVERT | TRY_CAST ...
Microsoft Learn
learn.microsoft.com › en-us › sql › t-sql › functions › cast-and-convert-transact-sql
CAST and CONVERT (Transact-SQL) - SQL Server | Microsoft Learn
For more information, see Nondeterministic conversion of literal date strings into DATE values. Starting with SQL Server 2012 (11.x), when using supplementary character (SC) collations, a CAST operation from nchar or nvarchar to an nchar or nvarchar type of smaller length won't truncate inside a surrogate pair.
SQL Tutorial
sqltutorial.org › home › sql date functions › sql convert string to date functions
SQL Convert String to Date Functions: CAST() and TO_DATE()
April 4, 2020 - This tutorial shows you how to use the CAST() and TO_DATE() to convert a string to a date in SQL.
SQL Shack
sqlshack.com › sql-server-functions-for-converting-string-to-date
SQL Server functions for converting a String to a Date
May 21, 2021 - Additionally, you can read more about implicitly converting date types in SQL Server, by referring to this article: Implicit conversion in SQL Server. The second approach for converting data types is the explicit conversion which is done by using some functions or tools. In SQL Server, converting a string to date explicitly can be achieved using CONVERT().
SQL Tutorial
sqltutorial.org › home › sql date functions › sql convert date to string functions
SQL Convert Date to String Functions: CAST() and TO_CHAR()
April 4, 2020 - The CAST() function returns a string that represents the date. The following statement returns the current date and time as a date and as a string: SELECT CURRENT_TIMESTAMP 'date', CAST(CURRENT_TIMESTAMP AS VARCHAR) 'date as a string'; Code language: SQL (Structured Query Language) (sql)
Top answer 1 of 4
86
That task should be done by the next layer up in your software stack. SQL is a data repository, not a presentation system
You can do it with
CONVERT(VARCHAR(10), fmdate(), 101)
But you shouldn't
2 of 4
32
select convert(varchar(10), fmdate, 101) from sery
101 is a style argument.
Rest of 'em can be found here.
CAST and CONVERT (Transact-SQL) - Date and time styles
Reddit
reddit.com › r/sql › how do i format a date or convert a date to a specific string?
r/SQL on Reddit: How do I format a date or convert a date to a specific string?
June 23, 2021 -
say the default format for the dates in my database is MM/DD/YYYY (01/02/2021).
What is the syntax to convert this to 'FY 2021 Q3'?
Any insight or help are appreciative.
Top answer 1 of 6
3
the default format for the dates in my database is MM/DD/YYYY (01/02/2021) Except it isn't. All date & time data types in SQL Server are stored as binary data, not as strings. They have no "format" - formatting is done by the client application (yes, even SSMS). When you enter a date like 01/02/2021 in an application, the application or SQL Server is making a guess about what you mean based on regional settings and possibly other factors. Unless you're storing your dates as strings. If you're doing that, we gotta have a chat. But like u/IHeartBadCode said, you really need a date table to do this kind of lookup/translation, not code embedded in a query.
2 of 6
2
Depends on how your business defines its Fiscal Years. In my experience January is never part of the third quarter.
SQLServerCentral
sqlservercentral.com › forums › topic › convert-text-to-date-datatype
Convert Text to Date DataType – SQLServerCentral Forums
August 14, 2012 - I need this because i am using this query in SSRS and when i export the result to excel it needs to be in Date DT. ... SSC Eights! ... yes i can do that but,how will sql know that my text is in dd/mm/yyyy format and not in mm/dd/yyyy or smthing else. ... yes i can do that but,how will sql know that my text is in dd/mm/yyyy for and not in mm/dd/yyyy or smthing else. ... The third value in the convert statement tells SQL Server the string value of the data/time is in dd/mm/yyyy format.
InfluxData
influxdata.com › home › how does date conversion work in sql? | influxdata
How Does Date Conversion Work in SQL? | InfluxData
October 6, 2023 - Let’s assume you want to change this string ‘12-12-2023’ to a date. ... Similarly, you can also use CAST to extract the date from your current date and time. ... Another function is CONVERT, an in-built function that allows users to convert an expression from one data type to another.
Top answer 1 of 10
203
The following query will get the current datetime and convert into string. with the following format yyyy-mm-dd hh:mm:ss(24h)
SELECT convert(varchar(25), getdate(), 120)
- SQLFiddle Demo
- SQL Server Date Formats
2 of 10
43
There are many different ways to convert a datetime to a string. Here is one way:
SELECT convert(varchar(25), getdate(), 121) – yyyy-mm-dd hh:mm:ss.mmm
See Demo
Here is a website that has a list of all of the conversions:
How to Format datetime & date in SQL Server
SQLServerCentral
sqlservercentral.com › blogs › sql-server-vs-oracle-convert-string-to-date-1
SQL Server vs Oracle: Convert string to date – SQLServerCentral
August 11, 2017 - Each of these functions is meant to be paired with the matching data type so you get just what you want. To go along with these you also have the ISDATE() function which tests the value to be sure it’s a date. CONVERT() is straight forward but there’s a catch. Let’s say you want to convert a string of “MMDDYY” to date.
GeeksforGeeks
geeksforgeeks.org › sql › sql-query-to-convert-datetime-to-string
SQL Query to Convert Datetime to String - GeeksforGeeks
July 23, 2025 - In order to convert a DateTime to a string, we can use CONVERT() and CAST() function.
DotFactory
dofactory.com › sql › convert-string-to-datetime
SQL Convert String to DATETIME
SELECT CONVERT(DATETIME, '2022-04-28') AS Datetime Try it live ... If no time is specified, it will be set to 00:00:00.000. CONVERT and TRY_CONVERT can convert string values to datetime.
W3Schools
w3schools.com › sql › func_mysql_str_to_date.asp
MySQL STR_TO_DATE() Function
String Functions: ASCII CHAR_LENGTH ... STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK Advanced Functions: BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION SQL Server Functions · String Functions: ...
Databricks
community.databricks.com › t5 › get-started-discussions › convert-string-date-to-date-after-changing-format › td-p › 39292
Convert string date to date after changing format - Databricks Community - 39292
August 8, 2023 - I changed their format into 'MM/DD/YYYY' using DATE_FORMAT() function. ... DATE_FORMAT() returns a string with with the format 01/14/2000. Now when I am trying to convert this string back to date with the same format using TO_DATE function, I am getting 2000-01-14 instead of 01/14/2000.
Snowflake Documentation
docs.snowflake.com › en › sql-reference › functions › to_date
TO_DATE , DATE | Snowflake Documentation
The display format for dates in the output is determined by the DATE_OUTPUT_FORMAT session parameter (default YYYY-MM-DD). If the format of the input parameter is a string that contains an integer: After the string is converted to an integer, the integer is treated as a number of seconds, ...
Oracle
forums.oracle.com › ords › apexds › post › convert-random-string-to-date-format-8534
Convert random string to date format - Oracle Forums
November 10, 2022 - Hello Experts, I would like to ask help on how to convert the string sample below to a date format. select * from ficticious_table; ID LNAME FNAME HIRE_STR 100 Smith John HIREA...
MSSQLTips
mssqltips.com › home › sql date format examples using convert function
SQL Date Format Examples using SQL CONVERT Function
September 26, 2025 - --SELECT a datetime column as a string formatted dd/mm/yyyy (4 digit year) SELECT TOP 3 CONVERT(CHAR(10), ExpectedDeliveryDate, 103) ExpectedDeliveryDateFormattedAsText FROM Purchasing.PurchaseOrders WHERE OrderDate < @Datetime; --SELECT a datetime column as a string formatted dd/mm/yy (2 digit year) SELECT TOP 3 CONVERT(CHAR(8), ExpectedDeliveryDate, 3) ExpectedDeliveryDateFormattedAsText FROM Purchasing.PurchaseOrders WHERE OrderDate < @Datetime; Once the query runs, review SQL CONVERT output as shown below.
SQLines
sqlines.com › sql-server-to-mariadb › convert_string_datetime
CONVERT Datetime to String - SQL Server to MariaDB Migration - SQLines Tools
In SQL Server you can use CONVERT function to convert a DATETIME value to a string with the specified style (string format). In MariaDB you can use the DATE_FORMAT function. SQL Server: -- 3rd parameter specifies 112 style (Date 'YYYYMMDD' format) SELECT CONVERT(CHAR(8), GETDATE(), 112); # 20170406