DateTime2 vs DateTime in SQL Server

0 votes

Which one:

is the recommended way to store date and time in SQL Server 2008+?

I'm aware that there are variations in precision (and likely storage capacity), but putting that aside for the time being, is there a document that lists the best practises for each situation, or should we just stick to datetime2?

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 406 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
1 answer

LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

At the top level there are mainly ...READ MORE

answered Feb 4, 2022 in Database by Neha
 • 9,060 points • 1,651 views
0 votes
1 answer

Function vs. Stored Procedure in SQL Server

Functions are calculated values that cannot make ...READ MORE

answered Feb 17, 2022 in Database by Neha
 • 9,060 points
edited Feb 17, 2022 by Neha • 18,346 views
0 votes
0 answers

SQL query to insert datetime in SQL Server

Using the SQL query below, I want ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
 • 38,010 points • 1,830 views
0 votes
1 answer

How to format datetime in SQL SERVER

In SQL Server 2012 and up you ...READ MORE

answered Sep 18, 2022 in Database by narikkadan
 • 63,420 points • 582 views
0 votes
1 answer

IN vs OR in the SQL WHERE Clause

I assume you want to know the ...READ MORE

answered Sep 24, 2018 in Database by DataKing99
 • 8,240 points • 3,351 views
0 votes
1 answer

What are the different authentication modes in SQL Server? How can it be changed?

Windows mode and Mixed Mode – SQL ...READ MORE

answered Oct 29, 2018 in Database by Sahiti
 • 6,370 points • 1,018 views
0 votes
0 answers

How can I select the first day of a month in SQL?

I only need to choose the given ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 392 views
0 votes
1 answer

SQL query to select dates between two dates

you should put those two dates between ...READ MORE

answered Nov 7, 2022 in Others by gaurav
 • 23,260 points • 2,510 views
0 votes
1 answer

How do I UPDATE from a SELECT in SQL Server?

MERGE INTO YourTable T USING ...READ MORE

answered Feb 3, 2022 in Database by Vaani
 • 7,020 points • 587 views
0 votes
0 answers

How do I UPDATE from a SELECT in SQL Server?

INSERT INTO Table (col1, col2, col3) SELECT col1, ...READ MORE

Feb 4, 2022 in Database by Vaani
 • 7,020 points • 327 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.