Click here to Skip to main content
15,509,322 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: SQL convert(datetime, number) wrong? Pin
PIEBALDconsult29-Jun-14 18:45
professionalPIEBALDconsult29-Jun-14 18:45 
Why do you think it's wrong?

SELECT DATEDIFF ( dd , '1900-01-01' , '2014-06-30' )
SELECT DATEADD ( dd, 41818 , '1900-01-01' )



Miller Nguyen wrote:
In Excel, it should be


What do you mean "it should be" ?
You'll never get very far if all you do is follow instructions.

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 
AnswerRe: Question about File Server / MySQL Database Pin
Peter Leow29-Jun-14 4:19
professionalPeter Leow29-Jun-14 4:19 

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.