#datetime2

[liyenz-blog]

SQL Server - Difference Between DATETIME and DATETIME2

SQL Server – Difference Between DATETIME and DATETIME2

I came across the article written by Pinal Dave about the difference between DATETIME and DATETIME2. In my years working as a database administrator, I did use DATETIME most of the time for database structure design. So far, I did not use the data type DATETIME2 before.

It becomes more interesting when he shared with us the problems when using DATETIME2 and SYSDATETIME(). In a short summary he…

View On WordPress

[essentialsql]

How To Calculate The Median Value of a Liust in SQLServer using PERCENTILE_DISC

How To Calculate The Median Value of a Liust in SQLServer using PERCENTILE_DISC

In this puzzle we’re going to learn how to find the person whose birthday, among others, is in the middle.  Knowing how to calculate the median value is a good skill to have.  As you start to explore business intelligence you’ll come across similar problems to solve.

Also, be sure to check out the bonus question.  We’ll work with date from colonial times.  The calendar was different, and you see…

View On WordPress

[sevennet-blog]

How to: Using SQL Server 2008 and SQL Server 2005 and date time

How to: Using SQL Server 2008 and SQL Server 2005 and date time

Using SQL Server 2008 and SQL Server 2005 and date time

I’ve built a entity framework model against a 2008 database. All works ok against the 2008 database. When I try to update the entity on a 2005 database I get this error.

The version of SQL Server in use does not support datatype 'datetime2

I specifically did not use any 2008 features when I built the database. I can’t find any reference to…

View On WordPress

[goodanswerbiz]

Fixed SQL Server datetime2 vs datetime #dev #it #asnwer

Fixed SQL Server datetime2 vs datetime #dev #it #asnwer

SQL Server datetime2 vs datetime

Which one:

datetime

datetime2

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

I’m aware of differences in precision (and storage space probably), but ignoring those for now, is there a best practice document on when to use what, or maybe we should just use datetime2 only?

Answer: SQL Server datetime2 vs datetime

I think DATETIME2 is the better…

View On WordPress

[sevennet-blog]

How to: SQL Server datetime2 vs datetime

How to: SQL Server datetime2 vs datetime

SQL Server datetime2 vs datetime

Which one:

datetime

datetime2

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

I’m aware of differences in precision (and storage space probably), but ignoring those for now, is there a best practice document on when to use what, or maybe we should just use datetime2 only?

Answer: SQL Server datetime2 vs datetime

DATETIME2has a date range of…

View On WordPress