Αποτελέσματα Αναζήτησης
25 Αυγ 2017 · Learn how to use the CAST () function to convert a value to a specified datatype in SQL Server. See syntax, parameters, examples and technical details of this function.
- Try It Yourself
Edit the SQL Statement, and click "Run SQL" to see the...
- The Try-Sqlserver Editor
Edit the SQL Statement, and click "Run SQL" to see the...
- Round
Parameter Description; number: Required. The number to be...
- Format
The FORMAT() function formats a value with the specified...
- Try It Yourself
Learn how to use the CAST () and TO_DATE () functions to convert a string to a date in SQL. See the syntax, examples and differences between the functions for different database systems.
2 Ιουλ 2013 · Syntax for CAST: CAST ( expression AS data_type [ ( length ) ] ) Syntax for CONVERT: CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) And CAST is ANSI-standard, which makes it more portable accross different database platforms.
21 Ιουλ 2018 · Learn how to use the CAST () and TO_CHAR () functions to format a date as a string in SQL. See examples of syntax, output and comparison of different database systems.
5 Ιουν 2018 · Learn how to use the CAST() function to convert an expression of one data type to another, such as string to date or time. See examples, syntax, and error messages for different data types and formats.
2 Ιουν 2023 · Learn how to use the SQL CAST function to convert one data type to another in Oracle, SQL Server, MySQL, and Postgres. See the syntax, parameters, valid data types, and examples of the CAST function.
In this tutorial, you will learn how to convert a datetime to a DATE in SQL Server by using the CONVERT(), TRY_CONVERT(), and CAST() functions.