No announcements
Found 2926344 threads
-
0 Votes
Checking for Date Null with SqlFunctions
Below is my solution.Answered | 2 Replies | 1066 Views | Created by denkyira - Tuesday, October 2, 2018 4:40 PM | Last reply by denkyira - Wednesday, October 3, 2018 12:02 PM -
0 Votes
Checking for null in my date with SqlFunctions.
I am exporting to excel and need to format the Date and check for nulls.Answered | 8 Replies | 82 Views | Created by Anonymous - Tuesday, October 2, 2018 4:57 PM | Last reply by Anonymous - Tuesday, October 2, 2018 6:59 PM -
0 Votes
Sharepoint 2013 check blank/null date?
And you also could check the value of Request Date by logging the Request Date to the history list.Answered | 1 Replies | 2773 Views | Created by acfff - Wednesday, April 6, 2016 9:57 PM | Last reply by Sara Fan - Thursday, April 7, 2016 5:58 AM -
0 Votes
INSERT INTO Null or Not Null Dates
If I test for the date being Null and use the NULL value and it the date exists then have an other statement with ##, this is fine and how I actually have ...Answered | 10 Replies | 848 Views | Created by BrianSir - Friday, November 20, 2015 7:08 PM | Last reply by Alphonse G - Saturday, November 28, 2015 1:16 AM -
0 Votes
Optional Date Parameter with Null
Check this code, where ( (field.date between @begindate and @enddate) or (@begindate is null and @endate is ...Answered | 1 Replies | 3190 Views | Created by KeithTexas - Friday, June 14, 2013 1:59 PM | Last reply by Yogisha Bhat - Friday, June 14, 2013 3:30 PM -
0 Votes
SqlFunction not accepting a CLR User Defined Data Type
I had to re-build my project in order for the changes to the properties to be picked up.Answered | 7 Replies | 3712 Views | Created by Jerome Haltom - work - Friday, September 21, 2012 9:41 PM | Last reply by Alex Chin - MSFT - Tuesday, September 25, 2012 5:41 PM -
0 Votes
null date
I mean a date variable with nothing.Answered | 3 Replies | 3019 Views | Created by Jackson_1990 - Wednesday, June 25, 2008 7:16 AM | Last reply by neonprimetime - Thursday, June 26, 2008 5:55 PM -
0 Votes
convert null to date
You can avoid this by calling the Nz function: ...Answered | 3 Replies | 2018 Views | Created by sourises - Tuesday, October 17, 2017 6:34 PM | Last reply by Ken Sheridan - Wednesday, October 18, 2017 12:33 PM -
0 Votes
Check if Zero and if so then NULL
Aside from the fact that I can't understand how you're going to convert a single byte into a date...Answered | 1 Replies | 5350 Views | Created by BigFatTree - Friday, May 7, 2010 9:16 PM | Last reply by Todd McDermid - Friday, May 7, 2010 10:16 PM -
0 Votes
check for null
Hasa, you can use IS NULL and IS NOT NULL.Answered | 2 Replies | 4259 Views | Created by Dr.X1987 - Friday, March 19, 2010 2:18 PM | Last reply by Abdshall - Friday, March 19, 2010 2:25 PM -
0 Votes
Working with null dates
Try the below: declare @d as smalldatetime set @d = null If (@d is null) Select '' Mydate Else select convert(date,@d) ...Answered | 15 Replies | 691 Views | Created by Arne MN - Monday, October 21, 2013 8:11 PM | Last reply by SQLZealots - Tuesday, October 22, 2013 4:43 PM -
0 Votes
My date column showing null values when pulling from Excel
Check your excel source if it has valid date data for DateCol2.Answered | 2 Replies | 2775 Views | Created by Spartaa - Wednesday, September 12, 2012 1:40 PM | Last reply by Spartaa - Wednesday, September 12, 2012 5:11 PM -
0 Votes
Not Null Date Default
This will work for me since I am dealing with birth dates and haven't run across anyone 110 years old yet :)Answered | 2 Replies | 5820 Views | Created by Toyist - Monday, August 30, 2010 3:41 PM | Last reply by Toyist - Tuesday, August 31, 2010 2:29 PM -
0 Votes
Date dimension being NULL
However there are two dates which can be null (even if this is missing data) in my database, and other fields of the record remain useful, so I can't simply discard those ...Answered | 4 Replies | 4509 Views | Created by pocky6 - Tuesday, January 12, 2010 9:48 AM | Last reply by pocky6 - Friday, January 15, 2010 2:24 PM -
0 Votes
Check for space or special character or date and return null or column value
ISDATE function to check whether it is indeed a valid date and avoid the ceremony.Answered | 2 Replies | 544 Views | Created by Spunny - Monday, August 1, 2016 3:21 PM | Last reply by Seif Wang - Tuesday, August 2, 2016 10:02 AM -
0 Votes
Checking for null
Does your file have spaces or does it have null characters, or both?Answered | 2 Replies | 1626 Views | Created by RVingComputer - Tuesday, October 9, 2012 8:50 PM | Last reply by Chris Dunaway - Wednesday, October 17, 2012 10:31 PM -
0 Votes
insert a null value into a date field
is there a difference between null and NULL ?Answered | 8 Replies | 11790 Views | Created by John Mendes - Friday, November 1, 2013 1:03 PM | Last reply by Gert-Jan Strik - Saturday, November 2, 2013 2:38 PM -
0 Votes
check for null
But the code below cannot be used for checking if the node has td tags.Answered | 9 Replies | 4581 Views | Created by l9429727 - Tuesday, April 5, 2011 7:08 PM | Last reply by Cookie Luo - Tuesday, April 12, 2011 2:14 AM -
6 Votes
Checking for NULL
Enjoyed my post?Answered | 17 Replies | 1042 Views | Created by Y a h y a - Wednesday, December 16, 2015 9:18 PM | Last reply by Erland Sommarskog - Saturday, December 19, 2015 10:58 AM -
3 Votes
Null date automatically converted to 1753
They are a particular default date.Answered | 12 Replies | 11638 Views | Created by Pikker1981 - Monday, March 26, 2007 8:07 AM | Last reply by DJ Rele - Wednesday, July 24, 2013 3:12 PM - Items 1 to 20 of 2926344 Next ›
No announcements