Click here to Skip to main content
15,671,405 members
Home / Discussions / Database
   

Database

 
AnswerRe: Complex SQL queries Pin
Richard MacCutchan3-Jul-14 5:22
mveRichard MacCutchan3-Jul-14 5:22 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 20:02
data modeling guy3-Jul-14 20:02 
AnswerRe: Complex SQL queries Pin
PIEBALDconsult3-Jul-14 5:53
professionalPIEBALDconsult3-Jul-14 5:53 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 20:03
data modeling guy3-Jul-14 20:03 
AnswerRe: Complex SQL queries Pin
Eddy Vluggen3-Jul-14 11:24
professionalEddy Vluggen3-Jul-14 11:24 
GeneralRe: Complex SQL queries Pin
Mycroft Holmes3-Jul-14 14:20
professionalMycroft Holmes3-Jul-14 14:20 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 20:05
data modeling guy3-Jul-14 20:05 
AnswerRe: Complex SQL queries Pin
Jörgen Andersson3-Jul-14 20:28
professionalJörgen Andersson3-Jul-14 20:28 
QuestionSQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 16:38
Miller Nguyen29-Jun-14 16:38 
I tried this

SQL
select convert(datetime, 41818) as mydate


result


SQL
2014-06-30 00:00:00.000


In Excel, it should be

6/28/2014


It's always 2 days in advance

Please help!

Thanks a lot
AnswerRe: SQL convert(datetime, number) wrong? Pin
PIEBALDconsult29-Jun-14 17:45
professionalPIEBALDconsult29-Jun-14 17:45 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 22:41
Miller Nguyen29-Jun-14 22:41 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller29-Jun-14 21:19
Bernhard Hiller29-Jun-14 21:19 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 22:38
professionalJörgen Andersson29-Jun-14 22:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
PIEBALDconsult30-Jun-14 3:39
professionalPIEBALDconsult30-Jun-14 3:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 3:53
professionalJörgen Andersson30-Jun-14 3:53 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 22:39
professionalJörgen Andersson29-Jun-14 22:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 22:52
Miller Nguyen29-Jun-14 22:52 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 23:03
professionalJörgen Andersson29-Jun-14 23:03 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller30-Jun-14 0:38
Bernhard Hiller30-Jun-14 0:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 1:15
professionalJörgen Andersson30-Jun-14 1:15 
AnswerRe: SQL convert(datetime, number) wrong? Pin
GuyThiebaut30-Jun-14 0:52
professionalGuyThiebaut30-Jun-14 0:52 
QuestionMySQL Stored Procs - Pin
ericgahn29-Jun-14 9:08
ericgahn29-Jun-14 9:08 
AnswerRe: MySQL Stored Procs - Pin
Wayne Gaylard29-Jun-14 22:37
professionalWayne Gaylard29-Jun-14 22:37 
GeneralRe: MySQL Stored Procs - Pin
ericgahn1-Jul-14 19:03
ericgahn1-Jul-14 19:03 
GeneralRe: MySQL Stored Procs - Pin
Wayne Gaylard1-Jul-14 19:28
professionalWayne Gaylard1-Jul-14 19:28 

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.