TechQA.

Question

Trying Convert and CAST is not changing "10.00000" to "10"

score 51 · Answer 1 · 2023-09-29T16:27:20.630000

0

Answer

51

Views

Trying Convert and CAST is not changing "10.00000" to "10"

51 views Asked by MaggieW At 29 September 2023 at 16:27

score 714 · Answer 2 · 2023-08-31T02:32:10.743000

CAST with bigquery - Invalid NUMERIC value:

714 views Asked by Juanca At 31 August 2023 at 02:32

score 44 · Answer 3 · 2023-08-15T00:42:55.013000

Need to convert column to datetime

44 views Asked by Leah Stortvedt At 15 August 2023 at 00:42

score 103 · Answer 4 · 2023-06-22T23:43:51.343000

How to write out/convert YYYY-MM-DD to "Month, DD, YYYY" in SQL

103 views Asked by Castaspella At 22 June 2023 at 23:43

score 56 · Answer 5 · 2023-06-07T22:13:15.473000

'convert' statement of sql in pyspark or spark...?

56 views Asked by Isabela Branco At 07 June 2023 at 22:13

score 55 · Answer 6 · 2023-04-17T20:26:41.857000

Creating a Date Field from a big string Field

55 views Asked by marceloasr At 17 April 2023 at 20:26

score 74 · Answer 7 · 2023-04-11T06:15:56.770000

SQL Format and Convert functions in a select statement

74 views Asked by Grismak At 11 April 2023 at 06:15

score 74 · Answer 8 · 2023-03-10T08:17:06.823000

SQL Server update same column using different conversion without overwriting

74 views Asked by Jose Mari Muguruza At 10 March 2023 at 08:17

score 97 · Answer 9 · 2023-01-11T16:13:21.603000

Find min date from a column which has values DD-MMM-YY format stored as string

97 views Asked by Xenon At 11 January 2023 at 16:13

score 251 · Answer 10 · 2022-12-23T07:34:11.273000

Exponential conversion to number is wrong in SQL Server

251 views Asked by Sriram At 23 December 2022 at 07:34

score 517 · Answer 11 · 2022-12-22T15:44:47.093000

How can I use cast in SQL with multiple column selections?

517 views Asked by lora At 22 December 2022 at 15:44

score 2371 · Answer 12 · 2022-03-21T07:28:02.370000

SQL - Insert Into - Convert Datatype

2.3k views Asked by qawas At 21 March 2022 at 07:28

score 44 · Answer 13 · 2022-01-06T06:51:39.333000

Select query unable to retrieve result

44 views Asked by ispostback At 06 January 2022 at 06:51

score 32 · Answer 14 · 2020-12-19T21:23:04.967000

Is there SQL function to update table by replacing one column with data (DIFFERENT TYPE) from another column (in a related table)?

32 views Asked by David At 19 December 2020 at 21:23

score 1424 · Answer 15 · 2020-10-26T04:38:23.570000

How do I update a varchar column that has a number by adding another number?

1.4k views Asked by mirons At 26 October 2020 at 04:38

score 388 · Answer 16 · 2020-10-05T14:43:31.210000

Problem with finding datetime entries which are related to today in a SQL Server table

388 views Asked by Iraj At 05 October 2020 at 14:43

score 3133 · Answer 17 · 2020-09-18T06:38:48.897000

Convert string to datetime - SQL

3.1k views Asked by SZenko At 18 September 2020 at 06:38

score 63 · Answer 18 · 2020-08-05T19:32:43.353000

Sort by year as nvarchar and then numerically

63 views Asked by Corey Franco At 05 August 2020 at 19:32

score 36 · Answer 19 · 2020-04-30T21:19:31.183000

set Nonnumeric as they come in to null

36 views Asked by an1234 At 30 April 2020 at 21:19

score 414 · Answer 20 · 2020-04-30T18:30:42.187000

XML input string got cut off when using convert() in sql

414 views Asked by cxc At 30 April 2020 at 18:30

TechQA.

List Question

Trying Convert and CAST is not changing "10.00000" to "10"

CAST with bigquery - Invalid NUMERIC value:

Need to convert column to datetime

How to write out/convert YYYY-MM-DD to "Month, DD, YYYY" in SQL

'convert' statement of sql in pyspark or spark...?

Creating a Date Field from a big string Field

SQL Format and Convert functions in a select statement

SQL Server update same column using different conversion without overwriting

Find min date from a column which has values DD-MMM-YY format stored as string

Exponential conversion to number is wrong in SQL Server

How can I use cast in SQL with multiple column selections?

SQL - Insert Into - Convert Datatype

Select query unable to retrieve result

Is there SQL function to update table by replacing one column with data (DIFFERENT TYPE) from another column (in a related table)?

How do I update a varchar column that has a number by adding another number?

Problem with finding datetime entries which are related to today in a SQL Server table

Convert string to datetime - SQL

Sort by year as nvarchar and then numerically

set Nonnumeric as they come in to null

XML input string got cut off when using convert() in sql

Popular Questions

Trending Questions