Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DateTIme field type conversion
Message
From
10/05/2000 01:12:39
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00367962
Message ID:
00367964
Views:
19
Look up in the docs for the CTOT command (character to Time). You'll have to convert your date to char and concatenate with your character field.

PF

>I want to convert a date and character field into a datetime field. In the table I currently have the date in a date field and the time in a character field. I want both to be in the datetime field. How do I convert it?
>
>TIA

(On an infant's shirt): Already smarter than Bush
Previous
Reply
Map
View

Click here to load this message in the networking platform