Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting the Date & Time from a DATETIME field
Message
From
25/02/2006 13:59:50
Sergey Berezniker
New York, United States
 
 
To
25/02/2006 06:39:04
Tore Bleken (Online)
Vear, Norway
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Extracting the Date & Time from a DATETIME field
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01098831
Message ID:
01099221
Views:
10
>Sorry, I remembered wrong. However, you can use the TTOC function to get the time portion.
>Date=TTOD(datetime)
>Date=TTOC(datetime,2)
You can but in what format? It depends on bunch of SET settings. I would rather use SUBSTR(TTOC(datetime,1),9). IN VFP9 - SUBSTR(TTOC(datetime,3),12)
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform