Viewing 15 posts - 46 through 60 (of 122 total)
Honestly, this is why I personally find it easier to just store anything in UTC if I'm ever working with time sensitive data, or multiple timezones (and I include...
September 28, 2020 at 3:54 pm
Unfortunately, it seems it isn't DST aware for all timezones, as Britain doesn't have a timezone listed, but I assume it suggest we use Greenwich Standard Time.
Greenwich...
September 28, 2020 at 2:28 pm
Does AT TIME ZONE know that it has to add 11 hours for CompletionDate from Friday but 10 hours for CompletionDate on Monday?
if yes - where does it take...
September 28, 2020 at 1:02 pm
Still does not solve the issue with DLS.
i worked with a system which was saving OrderDate as UTC datetime. And converted it to a local time on the way...
September 28, 2020 at 11:58 am
Haha! Look what appeared in today's daily digest email...
https://www.sqlservercentral.com/blogs/converting-a-datetime-to-utc
September 28, 2020 at 10:16 am
Disclaimer: I am not a networking/security person and have about 2 minutes free to throw this in: We had a slightly similar problem with the web front end to a...
September 28, 2020 at 9:31 am
With regard to DateTimes...
8<
We loaded up a lookup table for the different time zones and sub-time zones and purchased some data that lists every NPA/NXX (Area Code and...
September 25, 2020 at 2:44 pm
My guess would be that a document number should be an identifier. Identifiers are always measured on a nominal scale. Therefore, you document number should have been a string...
September 25, 2020 at 1:09 pm
With regard to DateTimes...
We have a core application, used for legal case management, partly black box. The application always converts the local datetimes, entered into the front end, to UTC...
September 25, 2020 at 9:30 am
Thank you Jeff for showing the right direction. I always had this issue of generating test data and now I have a plan and your teaching is very helpful....
September 25, 2020 at 8:55 am
"DECIMAL(18,10) means 8 digits to the left of the decimal point and 10 to the right. That seems like a very strange datatype for an "order quantity' column. It...
September 25, 2020 at 8:17 am
Strong advice: all tables, all databases, all the time, use appropriate data types. It really matters.
Obviously I agree with that principle, as a general rule. Would you say I...
September 24, 2020 at 5:12 pm
Ten centuries, I never knew where that advice came from but I told my sons that: "You don't need to know all the answers. You just need to know...
September 21, 2020 at 12:18 pm
Excellent article. Describes my hang-ups to a "T". I have read about this recently, but this articulates it in a very personal and relatable way.
It's funny, at a VERY young...
September 21, 2020 at 8:55 am
At the risk of going slightly off topic, can I ask the gurus' opinions of DDL triggers?
In my infancy as accidental, lone DBA - we were undergoing a large period...
September 17, 2020 at 9:32 am
Viewing 15 posts - 46 through 60 (of 122 total)