TechQA.

Question

How to convert '01/01/0001' to datetime2

score 2151 · Answer 1 · 2017-08-31T08:55:43.627000

0

Answer

2151

Views

How to convert '01/01/0001' to datetime2

2.1k views Asked by Kokombads At 31 August 2017 at 08:55

score 10250 · Answer 2 · 2017-09-05T10:33:30.053000

Concatenate date and string to create datetime in SQL

10.2k views Asked by SayCodeWell At 05 September 2017 at 10:33

score 7659 · Answer 3 · 2012-02-06T01:07:56.013000

Does SQL Server 2005 support datetime2

7.6k views Asked by ahmd0 At 06 February 2012 at 01:07

score 199 · Answer 4 · 2013-12-21T09:13:23.810000

Need output in dd/MM/yyyy format from table value pair

199 views Asked by Bhushan Mahajan At 21 December 2013 at 09:13

score 4820 · Answer 5 · 2014-01-08T14:19:00.050000

Datetime2 format to dd/mm/yyyy

4.8k views Asked by Kris Van den Bergh At 08 January 2014 at 14:19

score 3868 · Answer 6 · 2014-12-19T17:34:44.393000

SQL select from multiple tables based on datetime

3.8k views Asked by mkolker At 19 December 2014 at 17:34

score 4163 · Answer 7 · 2011-10-12T10:05:02.633000

Is number after DateTime2 is for nanosecond purpose?

4.1k views Asked by Sarawut Positwinyu At 12 October 2011 at 10:05

score 1115 · Answer 8 · 2011-10-12T11:44:41.437000

Is there a reason not to use DateTime2?

1.1k views Asked by Sarawut Positwinyu At 12 October 2011 at 11:44

score 4340 · Answer 9 · 2011-11-02T15:30:44.340000

How is SQL Server's timestamp2 supposed to work in JDBC?

4.3k views Asked by Pixel At 02 November 2011 at 15:30

score 1446 · Answer 10 · 2020-11-30T08:33:52.060000

How to remove trailing zeros from milliseconds value(datetime 2)in string format by one query

1.4k views Asked by Эльфия Валиева At 30 November 2020 at 08:33

score 573 · Answer 11 · 2022-04-04T13:10:12.320000

Error converting varchar to Datetime in a SQL Function

573 views Asked by qudsif At 04 April 2022 at 13:10

score 239 · Answer 12 · 2021-04-29T20:41:14.700000

datetime2 truncate to the last full 30 minute period

239 views Asked by Petter Östergren At 29 April 2021 at 20:41

score 128 · Answer 13 · 2018-11-16T22:31:41.897000

What are the dangers of converting all datetime columns in a database to datetime2

128 views Asked by PiotrS At 16 November 2018 at 22:31

score 1207 · Answer 14 · 2012-08-09T20:43:38.003000

DateTime2 is driving me crazy

1.2k views Asked by rochasdv At 09 August 2012 at 20:43

score 1392 · Answer 15 · 2012-10-17T07:29:01.050000

How to get the values in between a particular range timestamps

1.3k views Asked by user1716577 At 17 October 2012 at 07:29

score 96 · Answer 16 · 2021-06-06T17:41:37.573000

Joining tables based on datetime2 predicate

96 views Asked by thesnowplow At 06 June 2021 at 17:41

score 144 · Answer 17 · 2014-01-28T15:43:12.140000

LINQ2SQL Weirdness With DateTime2

144 views Asked by trilson86 At 28 January 2014 at 15:43

score 65 · Answer 18 · 2022-12-12T03:47:34.137000

DateTime2 prefixed with "T"

65 views Asked by Display name At 12 December 2022 at 03:47

score 125 · Answer 19 · 2023-01-05T07:18:17.000000

Column, parameter, or variable #6: Cannot find data type datetime2 in ASP.net core API project

125 views Asked by Harry At 05 January 2023 at 07:18

score 288 · Answer 20 · 2014-05-22T14:32:07.017000

My datetime2 comparison doesnt work where string does

288 views Asked by Fearghal At 22 May 2014 at 14:32

TechQA.

List Question

How to convert '01/01/0001' to datetime2

Concatenate date and string to create datetime in SQL

Does SQL Server 2005 support datetime2

Need output in dd/MM/yyyy format from table value pair

Datetime2 format to dd/mm/yyyy

SQL select from multiple tables based on datetime

Is number after DateTime2 is for nanosecond purpose?

Is there a reason not to use DateTime2?

How is SQL Server's timestamp2 supposed to work in JDBC?

How to remove trailing zeros from milliseconds value(datetime 2)in string format by one query

Error converting varchar to Datetime in a SQL Function

datetime2 truncate to the last full 30 minute period

What are the dangers of converting all datetime columns in a database to datetime2

DateTime2 is driving me crazy

How to get the values in between a particular range timestamps

Joining tables based on datetime2 predicate

LINQ2SQL Weirdness With DateTime2

DateTime2 prefixed with "T"

Column, parameter, or variable #6: Cannot find data type datetime2 in ASP.net core API project

My datetime2 comparison doesnt work where string does

Popular Questions

Popular Tags

Trending Questions