Viewing 15 posts - 781 through 795 (of 3,666 total)
itortu (5/26/2015)
I changed my original query to use 23:59:59, and that also gave me the missing record back.
SQL reads 11:59:59 AS AM. The the missing record was PM.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 26, 2015 at 11:22 am
Did you try your original query with '5/15/2015 23:59:59' Instead of '5/15/2015 11:59:59'?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 26, 2015 at 10:46 am
GilaMonster (5/22/2015)
Alvin Ramard (5/22/2015)
Gazareth (5/22/2015)
Jack Corbett (5/22/2015)
We do have white noise generatorsHuh?
Do we have them in any other colors? 😎
You laugh, but...
I had forgotten about it,...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 22, 2015 at 10:09 am
Gazareth (5/22/2015)
Jack Corbett (5/22/2015)
We do have white noise generatorsHuh?
Do we have them in any other colors? 😎
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 22, 2015 at 9:31 am
I agree with Jeff on the need for the technical questions.
I remember seeing a resume for a DBA that seemed to have good experience. I was eavesdropping on the...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 22, 2015 at 9:00 am
Beatrix Kiddo (5/22/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 22, 2015 at 8:30 am
Gary Varga (5/22/2015)
Eric M Russell (5/22/2015)
T_Peters (5/21/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 22, 2015 at 7:50 am
Other than reducing the number of databases to manage, I cannot see any benefits.
This would mean fewer databases to manage, but this database could, if not would, be a nightmare...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 22, 2015 at 7:39 am
Eirikur Eiriksson (5/20/2015)
Just one step left😎
USE TEMPDB;GO
SET NOCOUNT ON;
DECLARE @MY_TIME VARCHAR(100) = '2015-01-16T00:00:00.000-06:00';
SELECT CONVERT(DATETIMEOFFSET,@MY_TIME,127);
SELECT CONVERT(DATETIME,CONVERT(DATETIMEOFFSET,@MY_TIME,127),0);
Were you looking over my shoulder? 😉
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 20, 2015 at 1:39 pm
SELECT CONVERT(DATETIME2, '2015-01-16T16:06:14.577-06:00', 127) results in: 2015-01-16 16:06:14.5770000
Does this help?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 20, 2015 at 1:36 pm
Looks like the style is 127. Did you try convert specifying style 127?
https://technet.microsoft.com/en-us/library/ms187928%28v=sql.110%29.aspx
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 20, 2015 at 1:22 pm
Is there any chance you could do some SQL work where you are working now? Maybe there's a chance you could do so for a few hours a week. If...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 20, 2015 at 1:10 pm
Luis Cazares (5/20/2015)
Those questions are there because some people just copy, paste and execute code without analysing what they...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 20, 2015 at 1:06 pm
oops
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 20, 2015 at 12:03 pm
FYI, the =* and *= can easily be converted to Outer Joins so you could upgrade to SQL 2008 or higher.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 20, 2015 at 11:52 am
Viewing 15 posts - 781 through 795 (of 3,666 total)