>>Maybe [+] is not the right sign :-)
>>? CTOT(CHRTRAN("2002-10-05T04:04:04.0000000+02:00",[+],[-]))
>
>Yes.. same way I just made... the [+] generated by Visual Studio.. and no idea is it right sign or not.. and more.. realy no idea what means [-07:00] ;-)) Do you know what this addition means?
No :-(
Maybe -7 hours from GMT?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.