Array Format for date and time

[bartekd]

I am using ChrisL's _sql.au3 function. I have one issue with the Array and listView. When I run a particular query, it always removes all the spaces, colons, and dashes. Is there a way that it could be formatted better?

Just so you know what I am talking about, here is an example of the same query I ran using Autoit and Query Analyzer.

Results in Array

[0]|1st Dial

[1]|20090415153030

Results in Query Analyzer

1st Dial

------------------------------------------------------

2009-04-15 15:30:30.000

Thanks in Advance

[weaponx]

What is Query Analyzer? It's most likely formatting the dates for you. AutoIt is likely just leaving them in the SQL internal format.

[bartekd]

Its part of the SQL Server 2000 install. Is there a way to format this field in an array like the above?

[weaponx]

;Convert YYYYMMDDHHMMSS to YYYY-MM-DD HH:MM:SS
$original = "20090415153030"
$new = StringRegExpReplace($original, "\A(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})(?:.*)","$1-$2-$3 $4:$5:$6")
ConsoleWrite($new)

[Zedna]

version without RegExp:

$in = '20090415153030'
$out = DateFormat($in)
MsgBox(0,'Test',$in & ' --> ' & $out)

; yyyymmddhhmmss --> yyyy-mm-dd hh:mm:ss.sss
Func DateFormat($date)
 If $date = '' Then Return ''
 Return StringLeft($date,4) & '-' & StringMid($date,5,2) & '-' & StringMid($date,7,2) & ' ' & _
        StringMid($date,9,2) & ':' & StringMid($date,11,2) & ':' & StringMid($date,13,2) & '.000'
EndFunc

[SmOke_N]

version without RegExp:

Something like that exists? ...

[Zedna]

Something like that exists? ...

I'm not skilled in RegExp so I can't write such wonderfull RegExp things :-(

[Valuater]

Something like that exists? ...

I'm not skilled in RegExp so I can't write such wonderfull RegExp things :-(

Me either!!

8)

[bartekd]

;Convert YYYYMMDDHHMMSS to YYYY-MM-DD HH:MM:SS
$original = "20090415153030"
$new = StringRegExpReplace($original, "\A(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})(?:.*)","$1-$2-$3 $4:$5:$6")
ConsoleWrite($new)

Thanks allot, this works beautifully.