MySQL queries |
|
1 |
Set Data = Order.executeQuery("SELECT DATE_FORMAT(imerominia, '%d-%m-%Y') FROM esoda_exoda order by imerominia") |
when i make SELECT DATE_FORMAT(imerominia, '%d-%m-%Y') FROM esoda_exoda order by imerominia into my mysql editor everything is fine but when i return to jabaco and make...Set Data = Order.executeQuery("SELECT DATE_FORMAT(imerominia, '%d-%m-%Y') FROM esoda_exoda order by imerominia")
This post has been edited 1 times, last edit by "fomaxrge" (Oct 4th 2012, 3:34pm)
MySQL queries |
|
1 |
SELECT DATE_FORMAT(imerominia, '%d-%m-%Y') AS imerominia FROM esoda_exoda ORDER BY imerominia; |
imerominia = Format(imerominia, "dd-MM-yyyy")
in this case returns me always ...
04-04-0010
10-04-0004
04-04-0010
10-04-0004
04-04-0010
10-04-0004
Jabaco Source |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
Public Function Format(d As Date, fmt As String) As String Dim df As New java#text#SimpleDateFormat(fmt) Format = df.format(d) End Function Public Sub main(ByJava args() As String) Dim imerominia(3) As String imerominia(1) = "2008-09-17" imerominia(2) = "2008-09-18" imerominia(3) = "2008-09-19" Dim i As Integer For i=1 To 3 System.out.println(Format(imerominia(i), "dd-MM-yyyy")) Next i End Sub |
Source code |
|
1 2 3 |
17-09-2008 18-09-2008 19-09-2008 |
Jabaco Source |
|
1 2 3 4 5 6 7 8 9 10 |
Public Function Format(d As Date, fmt As String) As String Dim df As New java#text#SimpleDateFormat(fmt) Format = df.format(d) End Function Public Sub main(ByJava args() As String) Dim imerominia As String imerominia = "2012-04-11" System.out.println(Format(imerominia, "dd-MM-yyyy")) End Sub |
Source code |
|
1 |
11-04-2012 |
in this case returns me always ...
04-04-0010
10-04-0004
04-04-0010
10-04-0004
04-04-0010
10-04-0004
Jabaco Source |
|
1 2 3 4 5 6 7 8 9 10 |
Public Function Format(d As Date, fmt As String) As String Dim df As New java#text#SimpleDateFormat(fmt) Format = df.format(d) End Function Public Sub main(ByJava args() As String) Dim imerominia As String imerominia = "04-04-0010" System.out.println(Format(imerominia, "dd-MM-yyyy")) End Sub |
Quoted
10-04-0004
The above dates
04-04-0010
10-04-0004
are not included in my table.
Quoted
Also i want to format my imerominia variable that is used a mysql query in a loop
for example....
Do while Data.next()
...
imerominia=Data.getString("imerominia")
imerominia = Format(imerominia, "dd-MM-yyyy")
...
Loop
also i was trying today to make something like this ...
dateNow = Format(NOW, "dd,MM,yyyy") and returns me also a very strange date.
05-07-10????
Jabaco Source |
|
1 2 3 4 5 6 |
Do while Data.next() ... imerominia=Data.getString("imerominia") imerominia2 = Format(imerominia, "dd-MM-yyyy") ... Loop |
Jabaco Source |
|
1 2 3 4 5 6 7 8 |
Do while Data.next() ... imerominia=Data.getString("imerominia") System.out.println("imerominia: " + imerominia); imerominia2 = Format(imerominia, "dd-MM-yyyy") System.out.println("imerominia2: " + imerominia2); ... Loop |
Jabaco Source |
|
1 2 3 4 5 |
Public Function MyFormat(d As String) As String Dim sd() As String sd = Split(d,"-") MyFormat = sd(2) & "-" & sd(1) & "-" & sd(0) End Function |
Same here.hi again!
Finally my problem did not solved.
Can you please try this ...
MsgBox Format("06-08-2012", "yyyy-MM-dd") to tell me what is coming back to you?
to me it returns....0012-02-02????
Before you used your Format-function to convert a yyyy-MM-dd date to a dd-MM-yyyy date.Quoted
Why ?