This seems to be a timestamp. You can convert it to a string using a "To String" object writing text in timestamp format.
Your number will result as "THU 27/MAR/2008 17:31:57" with the default setting.
You can also use VEE Time & Date functions to get parts of the timestamp.
Herbert Bär
Industrial Engineering
Tel. +49 (0) 911 9411-129
Fax. +49 (0) 911 9411-261
eMail HYPERLINK "mailto:Herbert.Baer@rfmd.comPremierDevices.de"Herbert.Baer@rfmd.com
_____
Von: Vincent Petrone [mailto:vpetrone@kathrein.com]
Gesendet: Donnerstag, 27. März 2008 19:24
An: VRF
Betreff: [vrf] Convert Text String to Date & Time
Greetings from Southern Oregon,
I am working with a Paradox database that outputs the date and time as a text string such as 63342405117. I need to convert this to a date and time and insert it into a SQL Server database. I have been able to convert it to real64 and then get the date but not the time portion. I am using VEE 7.5. Any help is most appreciated.
Thanks,
Vincent Petrone
Test Software Engineer
Kathrein Inc., Scala Division
Medford, OR USA
(541) 618-5119
HYPERLINK "mailto:vpetrone@kathrein.com"vpetrone@kathrein.com
www.kathrein-scala.com
---
You are currently subscribed to vrf as: Herbert.Baer@premierdevices.de
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
_____
RFMD Germany GmbH
Löffelholzstraße 20
D - 90441 Nürnberg
Tel. +49 (0) 911 9411-0
Fax +49 (0) 911 9411-198
http://www.rfmd.com
Geschäftsführer: Robert Alan Bruggeworth, William Aldeen Priddy Jr. und Suzanne Beroset Rudy,
Handelsregister HR B 166 43, Amtsgericht Nürnberg
---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Your number will result as "THU 27/MAR/2008 17:31:57" with the default setting.
You can also use VEE Time & Date functions to get parts of the timestamp.
Herbert Bär
Industrial Engineering
Tel. +49 (0) 911 9411-129
Fax. +49 (0) 911 9411-261
eMail HYPERLINK "mailto:Herbert.Baer@rfmd.comPremierDevices.de"Herbert.Baer@rfmd.com
_____
Von: Vincent Petrone [mailto:vpetrone@kathrein.com]
Gesendet: Donnerstag, 27. März 2008 19:24
An: VRF
Betreff: [vrf] Convert Text String to Date & Time
Greetings from Southern Oregon,
I am working with a Paradox database that outputs the date and time as a text string such as 63342405117. I need to convert this to a date and time and insert it into a SQL Server database. I have been able to convert it to real64 and then get the date but not the time portion. I am using VEE 7.5. Any help is most appreciated.
Thanks,
Vincent Petrone
Test Software Engineer
Kathrein Inc., Scala Division
Medford, OR USA
(541) 618-5119
HYPERLINK "mailto:vpetrone@kathrein.com"vpetrone@kathrein.com
www.kathrein-scala.com
---
You are currently subscribed to vrf as: Herbert.Baer@premierdevices.de
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
_____
RFMD Germany GmbH
Löffelholzstraße 20
D - 90441 Nürnberg
Tel. +49 (0) 911 9411-0
Fax +49 (0) 911 9411-198
http://www.rfmd.com
Geschäftsführer: Robert Alan Bruggeworth, William Aldeen Priddy Jr. und Suzanne Beroset Rudy,
Handelsregister HR B 166 43, Amtsgericht Nürnberg
---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".