Click here to Skip to main content
15,566,496 members
Home / Discussions / Database
   

Database

 
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
jan 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
jan 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
jan 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
jan Meeling20-Aug-19 2:03 
Hi all,

I have it working know.

The solution is in the SQL string.

SELECT ID_BHV_Users, Voornaam , Achternaam , FORMAT (Geboorte_Datum, 'dd/MM/yyyy'), Porto_Nummer , Format (EHBO_Behaald, 'dd/MM/yyyy') , EHBO , BHV , Regiseur , Format ( Verlopen, 'dd/MM/yyyy') , Format (Laatste_herhaling, 'dd/MM/yyyy') , EHBO_nummer , verdieping , Ruimte , Email , Mobiel , Opmerking , Format (BHV_Behaald, 'dd/MM/yyyy') , Format (BHV_Verlopen, 'dd/MM/yyyy') , Format (Laatste_Herhaling_BHV, 'dd/MM/yyyy') , Ruisnaam , Format (Regisseur_Verlopen, 'dd/MM/yyyy') , Format (Regisseur_Behaald, 'dd/MM/yyyy') , Format (Regisseur_Herhaling, 'dd/MM/yyyy') , Active_no_yes FROM BHVUsers"

I use the format in the SQL string

You All thanks for putting me in the right direction.

Thanks
Jan Meeling Smile | Smile | :) Wink | Wink | ;)
QuestionProduct Architecture Pin
Chiranjana13-Aug-19 1:50
Chiranjana13-Aug-19 1:50 
AnswerRe: Product Architecture Pin
David Mujica13-Aug-19 4:50
David Mujica13-Aug-19 4:50 
GeneralRe: Product Architecture Pin
Chiranjana13-Aug-19 6:05
Chiranjana13-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
djtrixy2-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
rnbergren2-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
rnbergren2-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 
AnswerRe: I didn't design it but I need to get data out of it. Pin
Mycroft Holmes2-Aug-19 14:40
professionalMycroft Holmes2-Aug-19 14:40 
QuestionSQL Server: Facing problem to parse xml using xquery Pin
Mou_kol31-Jul-19 6:56
Mou_kol31-Jul-19 6:56 
Questionstructure question 2 Pin
Joan M18-Jul-19 22:25
professionalJoan M18-Jul-19 22:25 
AnswerRe: structure question 2 Pin
Richard Deeming19-Jul-19 2:11
mveRichard Deeming19-Jul-19 2:11 
GeneralRe: structure question 2 Pin
Joan M19-Jul-19 2:14
professionalJoan M19-Jul-19 2:14 
GeneralRe: structure question 2 Pin
Richard Deeming19-Jul-19 2:27
mveRichard Deeming19-Jul-19 2:27 
PraiseRe: structure question 2 Pin
Joan M19-Jul-19 2:31
professionalJoan M19-Jul-19 2:31 

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.