t-sql convert null to date

nullif([startdate],'NULL') returns [startdate] unless it equals t...

nullif([startdate],'NULL') returns [startdate] unless it equals to 'NULL' and then it returns NULL (a real NULL, not the string 'NULL') INSERT INTO.

⬇ Download Full Version

CONVERT statement. (I assume that CmmtExpirationDate is of type DATE, becau...

CONVERT statement. (I assume that CmmtExpirationDate is of type DATE, because if it isn't, it should have been mentioned in the question.).

⬇ Download Full Version

the format doesn't change although I'm doing an explicit conversi...

the format doesn't change although I'm doing an explicit conversion, the SQL Server uses 2 groups of four bytes to store a datetime dwn.220.v.ua Query - text and date time formatting issue.

⬇ Download Full Version

Here is the sql I wrote to get around the null date. However it won't ...

Here is the sql I wrote to get around the null date. However it won't work, because the date is returned as a string. ISNULL(CAST(Request.

⬇ Download Full Version

You could use a case statement: INSERT INTO [dbo].Production SELECT [field1...

You could use a case statement: INSERT INTO [dbo].Production SELECT [field1],[field2],CASE WHEN cast([datefield] as datetime).

⬇ Download Full Version

You can't get an empty string because you're returning the DATE i...

You can't get an empty string because you're returning the DATE is NULL, there is no need to convert it to a date, unless you wanted to.

⬇ Download Full Version

You will need to convert the column to a string. If you tell SQL to use �...

You will need to convert the column to a string. If you tell SQL to use '' as a datetime column you will get as that is the default date.

⬇ Download Full Version

When writing T-SQL, a lot of developers use either COALESCE or ISNULL in or...

When writing T-SQL, a lot of developers use either COALESCE or ISNULL in order to provide a default value in cases where the input is NULL. with the following error, since you can't implicitly convert a DATETIME to INT.

⬇ Download Full Version

Before I write a CLR function for convert a string to datetime with failed ...

Before I write a CLR function for convert a string to datetime with failed return null, could we do something in t-sql, so I don't need to convince.

⬇ Download Full Version

T-SQL supports two built-in methods for converting date/time data to charac...

T-SQL supports two built-in methods for converting date/time data to character data and vice versa. Post_SmallDateTime SMALLDATETIME NOT NULL.

⬇ Download Full Version

For instance, the following T-SQL tries to convert a date that follows the ...

For instance, the following T-SQL tries to convert a date that follows the day-month-year format.

⬇ Download Full Version

Yes. But you have to cast all values to varchar, which is a BAD idea. "...

Yes. But you have to cast all values to varchar, which is a BAD idea. "Zero" date for SQL server is January 1, Peter Larsson Helsingborg.

⬇ Download Full Version

For a date field, is it possible to have Tableau display the null returned ...

For a date field, is it possible to have Tableau display the null returned by a sql query as a blank cell instead of "Null"? I don't like this solution because it feels like a hack, but I created a calculated field based on the original.

⬇ Download Full Version

In SQL Server, you can use CONVERT or TRY_CONVERT function with an NULL if ...

In SQL Server, you can use CONVERT or TRY_CONVERT function with an NULL if conversion fails) SELECT TRY_CONVERT(DATETIME, '', ).

⬇ Download Full Version

T-SQL: Making a 01/01/ or NULL Date Field Be Blank. Posted on ME_User_Defin...

T-SQL: Making a 01/01/ or NULL Date Field Be Blank. Posted on ME_User_Defined AS [Editor], cast(COALESCE (MEDOCDATE.

⬇ Download Full Version