Help with date/time format

[RagsRevenge]

Hi,

I'm running a SQL query using ODBC. I'm displaying the results of this query in a Listview. A couple of the fields are Date/Time format, formatted as General Date in Access: 06/08/2009 10:34:23 according to my local settings.

Everything is working as expected, except my date/time fields are displaying in AutoIt (Listview and MsgBox) like 20090806103423, even if I include a format() call in my SQL query.

I've looked inside date.au3, and the existing format functions are no good for the format of my date/time.

Is there a built in function to format my date/time from my format, or is it something I just have to do myself? It's no problem to do it myself, but I just don't want to reinvent the wheel due to lack of knowledge,

Thanks,

D

[Andreik]

If all time is in there format isn't too hard to format time and date:

$DT = "20090806103423"

MsgBox(0,"Format",DTFormat($DT))

Func DTFormat($DT)
    If StringLen($DT) = 14 Then
        $YYYY = StringLeft($DT,4)
        $MM = StringMid($DT,5,2)
        $DD = StringMid($DT,7,2)
        $HH = StringMid($DT,9,2)
        $MN = StringMid($DT,11,2)
        $SS = StringRight($DT,2)
        Return $DD & "/" & $MM & "/" & $YYYY & " " & $HH & ":" & $MN & ":" & $SS
    EndIf
    Return -1
EndFunc

[RagsRevenge]

If all time is in there format isn't too hard to format time and date:

$DT = "20090806103423"

MsgBox(0,"Format",DTFormat($DT))

Func DTFormat($DT)
    If StringLen($DT) = 14 Then
        $YYYY = StringLeft($DT,4)
        $MM = StringMid($DT,5,2)
        $DD = StringMid($DT,7,2)
        $HH = StringMid($DT,9,2)
        $MN = StringMid($DT,11,2)
        $SS = StringRight($DT,2)
        Return $DD & "/" & $MM & "/" & $YYYY & " " & $HH & ":" & $MN & ":" & $SS
    EndIf
    Return -1
EndFunc

Thanks Andreik,

That was beyond the call of duty, as this was what I realised I'd have to do, if a built in function didn't already exist.

Props,

D