AnsweredAssumed Answered

AW: vrf Convert Text String to Date & Time

Question asked by VRFuser on Mar 28, 2008
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".  

Outcomes