enow.com Web Search

Search results

1. Results from the WOW.Com Content Network

2. sql server - T-SQL Cast versus Convert - Stack Overflow

   stackoverflow.com/questions/707335

   CAST is standard SQL, but CONVERT is only for the dialect T-SQL. We have a small advantage for convert in the case of datetime. With CAST, you indicate the expression and the target type; with CONVERT, there’s a third argument representing the style for the conversion, which is supported for some conversions, like between character strings ...

3. sql - datetime Cast or Convert? - Stack Overflow

   stackoverflow.com/questions/17433478

   At the first glance it seems there is no difference, except for the syntax: 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. sql.

4. sql server - Cast into a decimal with a specified amount of...

   stackoverflow.com/questions/6118325

   declare @decimalNum float =8931.0380106023125083. select ROUND(@decimalNum, @decimal,1) For trailing zeros use this: declare @decimal int=5. declare @decimalNum float =8931.12. select STR(@decimalNum, 25, @decimal) Please note, the above select will return a varchar type, not decimal, numeric, float or any other types.

5. What is the best way to convert an int or null to boolean value...

   stackoverflow.com/questions/177956

   Using CHAR (1) or INT might be more wise. Additionally, for SQL Server: "The string values 'TRUE' and 'FALSE' can be converted to bit values: 'TRUE' is converted to 1 and 'FALSE' is converted to 0." Using a varchar when OP explicitly asks for a boolean doesn't seem to be the correct solution.

6. sql - how to convert date to a format `mm/dd/yyyy` - Stack...

   stackoverflow.com/questions/18568410

   Which means that the data will be stored in the server in its original format but when the output is displayed you can control how it will be displayed. To convert a column in dd/mm/yyyy format you can use the below: Imagine there is a table called Employee_Details as below: ID Dept Salary DOB.

7. sql server - How to convert a datetime to string in T-SQL - Stack...

   stackoverflow.com/questions/15029860

   In addition to the CAST and CONVERT functions in the previous answers, if you are using SQL Server 2012 and above you use the FORMAT function to convert a DATETIME based type to a string. To convert back, use the opposite PARSE or TRYPARSE functions.

8. sql server - SQL: How use case and cast in a query? - Stack...

   stackoverflow.com/questions/5642165

   11. You might just want to solve this in general and deal with any non-int value the same way. INSERT INTO labbd11..movie(title, year) SELECT movies.title, CASE WHEN IsNumeric(movies.mvyear+ '.0e0') <> 1 THEN NULL. ELSE CAST (movies.mvyear AS INT) END. FROM disciplinabd..movies. See this question.

9. Best approach to remove time part of datetime in SQL Server

   stackoverflow.com/questions/1177449

   For SQL Server 2008+, you can CAST to date i.e. CAST(getdate() AS date). Or just use date datatype so no time to remove. Edit, Jan 2012. A worked example of how flexible this is: Need to calculate by rounded time or date figure in sql server. Edit, May 2012

10. sql - Convert Datetime column from UTC to local time in select...

    stackoverflow.com/questions/8038744

    2. It's simple. Try this for Azure SQL Server: SELECT YourDateTimeColumn AT TIME ZONE 'Eastern Standard Time' FROM YourTable. For Local SQL Server : SELECT CONVERT(datetime2, SWITCHOFFSET(CONVERT(datetimeoffset, gETDATE()), DATENAME(TzOffset, gETDATE() AT TIME ZONE 'Eastern Standard Time'))) FROM YourTable.

11. select - Convert INT to VARCHAR SQL - Stack Overflow

    stackoverflow.com/questions/19979532

    0. CONVERT(DATA_TYPE , Your_Column) is the syntax for CONVERT method in SQL. From this convert function we can convert the data of the Column which is on the right side of the comma (,) to the data type in the left side of the comma (,) Please see below example. SELECT CONVERT (VARCHAR(10), ColumnName) FROM TableName.