TechQA.

Question

MySQL STR_TO_DATE returns NULL when using week number directive (%U, %u, %V or %v)

score 74 · Answer 1 · 2024-01-30T19:25:42.787000

0

Answer

74

Views

MySQL STR_TO_DATE returns NULL when using week number directive (%U, %u, %V or %v)

74 views Asked by Hans At 30 January 2024 at 19:25

score 125 · Answer 2 · 2023-12-16T15:12:05.163000

STR_TO_DATE in mariaDB results in NULL

125 views Asked by Stefan Bongers At 16 December 2023 at 15:12

score 46 · Answer 3 · 2023-07-16T05:05:46.650000

ValueError: time data 'X' does not match format '%m/%d/%y %H:%M' (match)

46 views Asked by user22234214 At 16 July 2023 at 05:05

score 21 · Answer 4 · 2023-05-09T17:23:04.377000

How do I parse a MySQL date string where the month doesn't have a leading zero?

21 views Asked by Tyler At 09 May 2023 at 17:23

score 159 · Answer 5 · 2023-03-20T13:58:40.170000

STR_TO_DATE equivalent in snowflake

159 views Asked by Akhil At 20 March 2023 at 13:58

score 89 · Answer 6 · 2023-03-19T17:14:58.400000

How to load CSV data into MYSQL to get a TIME datatype in 24 HR format

89 views Asked by Lonestar101 At 19 March 2023 at 17:14

score 120 · Answer 7 · 2023-01-04T20:11:51.137000

How to update a MYSQL table column from Varchar data type to a time

120 views Asked by Lonestar101 At 04 January 2023 at 20:11

score 91 · Answer 8 · 2022-04-18T15:37:25.563000

How does BETWEEN keyword works into the WHERE statement

91 views Asked by Lucas F At 18 April 2022 at 15:37

score 588 · Answer 9 · 2022-02-19T04:41:10.760000

spark to_date function - how to convert 31-DEC-98 to 1998-12-31 not 2098-12-31

588 views Asked by mon At 19 February 2022 at 04:41

score 171 · Answer 10 · 2022-02-18T18:32:51.960000

How to convert str to timestamp in dataframe?

171 views Asked by Chicory At 18 February 2022 at 18:32

score 329 · Answer 11 · 2022-01-10T03:51:24.253000

How to write query for date exact match in mysql

329 views Asked by sen At 10 January 2022 at 03:51

score 908 · Answer 12 · 2021-12-24T04:48:20.870000

Error Code: 1193. Unknown system variable 'lastmodified' 0.000 sec from converted datetime in mysql workbench

908 views Asked by sunlong ngouv At 24 December 2021 at 04:48

score 185 · Answer 13 · 2021-10-21T05:16:26.433000

Convert a date string with different formatting's and month abbreviation in Dutch using to_date in PySpark

185 views Asked by John Doe At 21 October 2021 at 05:16

score 298 · Answer 14 · 2021-08-30T17:22:11.857000

str_to_date returning incorrect year value

298 views Asked by willwonkforfood At 30 August 2021 at 17:22

score 85 · Answer 15 · 2021-08-28T17:16:14.430000

How do I load data from XML where date is in %W %e, %Y format?

85 views Asked by Rob Campbell At 28 August 2021 at 17:16

score 43 · Answer 16 · 2021-08-06T06:09:26.377000

Unable to read datetime data with STR_TO_DATE() in MySQL LOAD operation

43 views Asked by Calcutta At 06 August 2021 at 06:09

score 430 · Answer 17 · 2021-07-08T14:07:49.520000

Query for daily before 11am with MySQL

430 views Asked by Alf Müller At 08 July 2021 at 14:07

score 219 · Answer 18 · 2021-07-06T19:15:01.100000

Format date in PHP MMddyyyyHHmmss to m-d-y

219 views Asked by Vincy Joseph At 06 July 2021 at 19:15

score 589 · Answer 19 · 2021-05-16T01:28:59.167000

Mysql str_to_date with convert_tz returns NULL

589 views Asked by TenG At 16 May 2021 at 01:28

score 507 · Answer 20 · 2021-04-22T10:32:05.087000

Incorrect datetime value loading data into MySQL from file with str_to_date function

507 views Asked by mcflurry At 22 April 2021 at 10:32

TechQA.

List Question

MySQL STR_TO_DATE returns NULL when using week number directive (%U, %u, %V or %v)

STR_TO_DATE in mariaDB results in NULL

ValueError: time data 'X' does not match format '%m/%d/%y %H:%M' (match)

How do I parse a MySQL date string where the month doesn't have a leading zero?

STR_TO_DATE equivalent in snowflake

How to load CSV data into MYSQL to get a TIME datatype in 24 HR format

How to update a MYSQL table column from Varchar data type to a time

How does BETWEEN keyword works into the WHERE statement

spark to_date function - how to convert 31-DEC-98 to 1998-12-31 not 2098-12-31

How to convert str to timestamp in dataframe?

How to write query for date exact match in mysql

Error Code: 1193. Unknown system variable 'lastmodified' 0.000 sec from converted datetime in mysql workbench

Convert a date string with different formatting's and month abbreviation in Dutch using to_date in PySpark

str_to_date returning incorrect year value

How do I load data from XML where date is in %W %e, %Y format?

Unable to read datetime data with STR_TO_DATE() in MySQL LOAD operation

Query for daily before 11am with MySQL

Format date in PHP MMddyyyyHHmmss to m-d-y

Mysql str_to_date with convert_tz returns NULL

Incorrect datetime value loading data into MySQL from file with str_to_date function

Popular Questions

Trending Questions