Click here to Skip to main content
15,798,592 members
Home / Discussions / Database
   

Database

 
AnswerRe: Complex SQL queries Pin
Eddy Vluggen3-Jul-14 12:24
professionalEddy Vluggen3-Jul-14 12:24 
GeneralRe: Complex SQL queries Pin
Mycroft Holmes3-Jul-14 15:20
professionalMycroft Holmes3-Jul-14 15:20 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 21:05
data modeling guy3-Jul-14 21:05 
AnswerRe: Complex SQL queries Pin
Jörgen Andersson3-Jul-14 21:28
professionalJörgen Andersson3-Jul-14 21:28 
QuestionSQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 17:38
Miller Nguyen29-Jun-14 17:38 
AnswerRe: SQL convert(datetime, number) wrong? Pin
PIEBALDconsult29-Jun-14 18:45
professionalPIEBALDconsult29-Jun-14 18:45 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 23:41
Miller Nguyen29-Jun-14 23:41 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller29-Jun-14 22:19
Bernhard Hiller29-Jun-14 22:19 
What the f...? You are right, I tested it.
Look at day number 0: with SQL Server, it is Jan 1, 1900; with Excel: Jan 0, 1900.
The next bug is the leap year: Excel treats 1900 as a leap year (that's wrong!), while SQL Server correctly knows that 1900 is not a leap year.
In sum, those differences account for the 2 days difference in current dates.
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 23:38
professionalJörgen Andersson29-Jun-14 23:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
PIEBALDconsult30-Jun-14 4:39
professionalPIEBALDconsult30-Jun-14 4:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 4:53
professionalJörgen Andersson30-Jun-14 4:53 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 23:39
professionalJörgen Andersson29-Jun-14 23:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 23:52
Miller Nguyen29-Jun-14 23:52 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 0:03
professionalJörgen Andersson30-Jun-14 0:03 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller30-Jun-14 1:38
Bernhard Hiller30-Jun-14 1:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 2:15
professionalJörgen Andersson30-Jun-14 2:15 
AnswerRe: SQL convert(datetime, number) wrong? Pin
GuyThiebaut30-Jun-14 1:52
professionalGuyThiebaut30-Jun-14 1:52 
QuestionMySQL Stored Procs - Pin
ericgahn29-Jun-14 10:08
ericgahn29-Jun-14 10:08 
AnswerRe: MySQL Stored Procs - Pin
Wayne Gaylard29-Jun-14 23:37
professionalWayne Gaylard29-Jun-14 23:37 
GeneralRe: MySQL Stored Procs - Pin
ericgahn1-Jul-14 20:03
ericgahn1-Jul-14 20:03 
GeneralRe: MySQL Stored Procs - Pin
Wayne Gaylard1-Jul-14 20:28
professionalWayne Gaylard1-Jul-14 20:28 
QuestionQuestion about File Server / MySQL Database Pin
Jassim Rahma29-Jun-14 3:30
Jassim Rahma29-Jun-14 3:30 
AnswerRe: Question about File Server / MySQL Database Pin
Peter Leow29-Jun-14 4:19
professionalPeter Leow29-Jun-14 4:19 
AnswerRe: Question about File Server / MySQL Database Pin
Bernhard Hiller29-Jun-14 22:12
Bernhard Hiller29-Jun-14 22:12 
Questiondatabase Pin
sheikh muneeb28-Jun-14 8:18
sheikh muneeb28-Jun-14 8:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.