Dear visitor, welcome to Jabaco - Community. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.
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 ?