Search results
21 mar 2013 · lhd.CreatedDate is a DateTime field and is non-nullable. I want to display an empty string if the field is the minimum date (1/1/1900), but my CASE statement doesn't work; CreatedDate displays 1900-01-01 00:00:00.000 in my query when that value is in the database. I'm using SQL Server 2008 R2.
5 paź 2017 · The best way to understand how date math works is to break a query down into its parts. Start with this: SELECT GETUTCDATE() AS utc_date On this particular day, it returns 2017-10-04 19:34:20.050. In date math, the number 0 and the date 1900-01-01 are interchangeable.
A DATETIME value can have different levels of precision. It can store the year, month, day, and hour ('2016-12-19 06'), or even the minutes and seconds ('2016-12-19 06:30:45'). INTERVAL: Represents elapsed time. Examples of interval values are: "1 day", "2 hours", "2 hours, 30 minutes and 20 seconds", "10 years".
16 maj 2022 · The first thing I need to show you is that with the DATEADD and DATEDIFF functions, some dates and numbers are interchangeable. For instance: SELECT DATEDIFF(DAY, 0, SYSDATETIME()) AS [what does zero mean?], DATEDIFF(DAY, '19000101', SYSDATETIME()) AS [it means 1900-01-01];
17 lis 2015 · You can't get an empty string because you're returning the DATE value type from ISNULL. Per the docs, ISNULL. Returns the same type as check_expression. If a literal NULL is provided as check_expression, returns the datatype of the replacement_value.
15 mar 2022 · You’ll begin by performing arithmetic and using various functions with dates and times using only the SELECT statement. Then you’ll practice by running queries on sample data, and you’ll learn how to implement the CAST function to make the output more digestible to read.
29 sty 2022 · SQL can use mathematical expressions to query and manipulate data by retrieving it from your database table and different columns. This helps with generating new information about the data you’re interested in analyzing.
