Click here to Skip to main content
15,119,514 members
Home / Discussions / Database
   

Database

 
QuestionDate format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling18-Aug-19 23:15
Memberjan Meeling18-Aug-19 23:15 
QuestionRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan18-Aug-19 23:54
mveRichard MacCutchan18-Aug-19 23:54 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling19-Aug-19 2:39
Memberjan Meeling19-Aug-19 2:39 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Victor Nijegorodov19-Aug-19 4:20
MemberVictor Nijegorodov19-Aug-19 4:20 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan19-Aug-19 5:23
mveRichard MacCutchan19-Aug-19 5:23 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Victor Nijegorodov19-Aug-19 1:19
MemberVictor Nijegorodov19-Aug-19 1:19 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling19-Aug-19 2:43
Memberjan Meeling19-Aug-19 2:43 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Eddy Vluggen19-Aug-19 2:12
professionalEddy Vluggen19-Aug-19 2:12 
Usually you don't include the password for the sa-account in the question. Usually we also frown on "SELECT *", and weirdly, you use a "using" clause for the connection but not for the disposable command.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling19-Aug-19 2:55
Memberjan Meeling19-Aug-19 2:55 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Eddy Vluggen19-Aug-19 3:03
professionalEddy Vluggen19-Aug-19 3:03 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling20-Aug-19 2:02
Memberjan Meeling20-Aug-19 2:02 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan20-Aug-19 5:20
mveRichard MacCutchan20-Aug-19 5:20 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling20-Aug-19 8:39
Memberjan Meeling20-Aug-19 8:39 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan20-Aug-19 22:17
mveRichard MacCutchan20-Aug-19 22:17 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling20-Aug-19 2:03
Memberjan Meeling20-Aug-19 2:03 
QuestionProduct Architecture Pin
Chiranjana13-Aug-19 1:50
MemberChiranjana13-Aug-19 1:50 
AnswerRe: Product Architecture Pin
David Mujica13-Aug-19 4:50
MemberDavid Mujica13-Aug-19 4:50 
GeneralRe: Product Architecture Pin
Chiranjana13-Aug-19 6:05
MemberChiranjana13-Aug-19 6:05 
AnswerRe: Product Architecture Pin
Mycroft Holmes13-Aug-19 13:50
professionalMycroft Holmes13-Aug-19 13:50 
Questioncookies vs sessions for storing users id for ecommerce site Pin
djtrixy2-Aug-19 22:48
Memberdjtrixy2-Aug-19 22:48 
AnswerRe: cookies vs sessions for storing users id for ecommerce site Pin
Afzaal Ahmad Zeeshan3-Aug-19 5:02
mveAfzaal Ahmad Zeeshan3-Aug-19 5:02 
QuestionI didn't design it but I need to get data out of it. Pin
rnbergren2-Aug-19 5:23
Memberrnbergren2-Aug-19 5:23 
AnswerRe: I didn't design it but I need to get data out of it. Pin
Richard Deeming2-Aug-19 5:51
mveRichard Deeming2-Aug-19 5:51 
GeneralRe: I didn't design it but I need to get data out of it. Pin
rnbergren2-Aug-19 9:12
Memberrnbergren2-Aug-19 9:12 
AnswerRe: I didn't design it but I need to get data out of it. Pin
ZurdoDev2-Aug-19 11:33
professionalZurdoDev2-Aug-19 11:33 

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.