Viewing 9 posts - 1 through 9 (of 9 total)
This article describes displaying dates, not storing date values in a database. When a date is displayed in a text format, yyyyMMdd, with or without separators, is the format that...
January 16, 2019 at 8:07 am
I can curse with the best of them, but I choose to refrain from such language in the presence of others. Steve is correct stating that we in the...
August 29, 2012 at 6:27 am
dirty (2/29/2012)
The...
February 29, 2012 at 5:37 pm
My point is why use a database process to act on a file system. Let the database system do what it is intended to do and, likewise, let the...
February 24, 2012 at 8:01 am
Good grief! Talk about using a sledgehammer to drive a tack.
February 24, 2012 at 6:43 am
The absolute BEST reward I have ever received for hard work was an all-expense-paid trip for my family to Disney World. My boss even placed "gross it up" on...
April 16, 2010 at 11:44 am
Odd that replacing the CAST(10000,NUMERIC(38,10)) with 10000 gives the more precise result 0.0001675740.
Also odd that Sybase 15.0.2 gives the result 0.0001675740 with the original query. You'd think running the...
December 4, 2009 at 7:26 am
I don't believe this is the first layoff at Microsoft. A friend was laid off from their graphics department in the 1990's.
March 24, 2009 at 7:06 am
The third solution returns "51" for DOB 08/21/1957.
select DATEDIFF(yy, '08/21/1957', GETDATE()) - CASE WHEN DATEPART(mm, '08/21/1957') >= DATEPART(mm, GETDATE()) AND DATEPART(d, '08/21/1957') >= DATEPART(d, GETDATE()) THEN 0 ELSE 1...
March 6, 2008 at 6:59 am
Viewing 9 posts - 1 through 9 (of 9 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy