Click here to Skip to main content
14,457,936 members
   

Database

 
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
communityengineerRichard 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
communityengineerRichard 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 
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 
Hi Bastard,

I have removed the password and this is only in a test enviroment,

And what do you mean with

Usually we also frown on "SELECT *", and weirdly, you use a "using" clause for the connection but not for the disposable command.

Thanks
Regards
Jan Meeling
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
communityengineerRichard 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
communityengineerRichard 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
MemberMycroft 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
mvaAfzaal 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
communityengineerRichard 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
mveZurdoDev2-Aug-19 11:33 
AnswerRe: I didn't design it but I need to get data out of it. Pin
Mycroft Holmes2-Aug-19 14:40
MemberMycroft Holmes2-Aug-19 14:40 

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.