Click here to Skip to main content
15,512,632 members
Home / Discussions / Database
   

Database

 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 21:02
data modeling guy3-Jul-14 21:02 
AnswerRe: Complex SQL queries Pin
PIEBALDconsult3-Jul-14 6:53
professionalPIEBALDconsult3-Jul-14 6:53 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 21:03
data modeling guy3-Jul-14 21:03 
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 
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 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 
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 

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.