Click here to Skip to main content
14,391,232 members
   

Database

 
QuestionSQL Remote Connection Problem Pin
Kevin Marois19-Aug-19 8:52
professionalKevin Marois19-Aug-19 8:52 
AnswerRe: SQL Remote Connection Problem Pin
Richard Deeming19-Aug-19 9:45
communityengineerRichard Deeming19-Aug-19 9:45 
GeneralRe: SQL Remote Connection Problem Pin
Kevin Marois19-Aug-19 10:21
professionalKevin Marois19-Aug-19 10:21 
GeneralRe: SQL Remote Connection Problem Pin
Richard Deeming19-Aug-19 10:28
communityengineerRichard Deeming19-Aug-19 10:28 
GeneralRe: SQL Remote Connection Problem Pin
Kevin Marois19-Aug-19 10:42
professionalKevin Marois19-Aug-19 10:42 
GeneralRe: SQL Remote Connection Problem - UPDATE Pin
Kevin Marois19-Nov-19 8:39
professionalKevin Marois19-Nov-19 8:39 
GeneralRe: SQL Remote Connection Problem - UPDATE Pin
Richard Deeming19-Nov-19 8:51
communityengineerRichard Deeming19-Nov-19 8:51 
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
mveEddy 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 
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
mveEddy 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 
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
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 

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.