Click here to Skip to main content
15,904,935 members
Home / Discussions / Database
   

Database

 
GeneralRe: how do I need to create a module for mysql command handler ? Pin
Santhoshpettacode26-Feb-14 20:02
professionalSanthoshpettacode26-Feb-14 20:02 
Questiondatetime problem Pin
Member 1026351925-Feb-14 19:45
Member 1026351925-Feb-14 19:45 
AnswerRe: datetime problem PinPopular
Kornfeld Eliyahu Peter25-Feb-14 20:25
professionalKornfeld Eliyahu Peter25-Feb-14 20:25 
GeneralRe: datetime problem Pin
Member 1026351925-Feb-14 21:39
Member 1026351925-Feb-14 21:39 
AnswerRe: datetime problem Pin
Kornfeld Eliyahu Peter25-Feb-14 21:44
professionalKornfeld Eliyahu Peter25-Feb-14 21:44 
GeneralRe: datetime problem Pin
Bernhard Hiller25-Feb-14 21:46
Bernhard Hiller25-Feb-14 21:46 
AnswerRe: datetime problem Pin
jschell26-Feb-14 9:26
jschell26-Feb-14 9:26 
AnswerRe: datetime problem Pin
GuyThiebaut26-Feb-14 21:49
professionalGuyThiebaut26-Feb-14 21:49 
Databases save datetime values as numbers.

There is no datetime format in which the computer system stores a datetime.
Once you understand this you can then understand that the format of the datetime data returned to you will be dependent on the collation of your database, when you perform a simple select,or the format you extract the data as.

All you need to remember is that the datetime value is saved, within the database, as a number and you will then understand that all formatting issues are resolvable.

N.B. for this reason never save a datetime as a string as if you do you will lose precision.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

QuestionHow to use temporary tables in SQL Server 2008? Pin
Rakesh Meel24-Feb-14 1:58
professionalRakesh Meel24-Feb-14 1:58 
AnswerRe: How to use temporary tables in SQL Server 2008? Pin
David Mujica24-Feb-14 3:18
David Mujica24-Feb-14 3:18 
QuestionHelp required on Database Model Pin
Nitheesh George23-Feb-14 6:05
Nitheesh George23-Feb-14 6:05 
AnswerRe: Help required on Database Model Pin
Mycroft Holmes23-Feb-14 11:52
professionalMycroft Holmes23-Feb-14 11:52 
AnswerRe: Help required on Database Model Pin
Eddy Vluggen24-Feb-14 8:17
professionalEddy Vluggen24-Feb-14 8:17 
AnswerRe: Help required on Database Model Pin
Duncan Edwards Jones26-Feb-14 11:06
professionalDuncan Edwards Jones26-Feb-14 11:06 
Questionintricate date query sql Pin
Martin Niemandt19-Feb-14 22:07
Martin Niemandt19-Feb-14 22:07 
AnswerRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 22:19
mveRichard MacCutchan19-Feb-14 22:19 
GeneralRe: intricate date query sql Pin
Martin Niemandt19-Feb-14 22:28
Martin Niemandt19-Feb-14 22:28 
GeneralRe: intricate date query sql Pin
Richard MacCutchan19-Feb-14 23:08
mveRichard MacCutchan19-Feb-14 23:08 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:11
Martin Niemandt20-Feb-14 0:11 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:16
mveRichard MacCutchan20-Feb-14 0:16 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:24
Martin Niemandt20-Feb-14 0:24 
GeneralRe: intricate date query sql Pin
Richard MacCutchan20-Feb-14 0:29
mveRichard MacCutchan20-Feb-14 0:29 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 0:41
Martin Niemandt20-Feb-14 0:41 
AnswerRe: intricate date query sql Pin
Mycroft Holmes20-Feb-14 12:01
professionalMycroft Holmes20-Feb-14 12:01 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 18:53
Martin Niemandt20-Feb-14 18:53 

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.