Extracting the Date & Time from a DATETIME field

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Extracting the Date & Time from a DATETIME field

Message

25/02/2006 13:59:50

25/02/2006 06:39:04

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Versions des environnements

Visual FoxPro:

VFP 8

OS:

Windows XP SP1

Network:

Windows 2000 Server

Database:

Visual FoxPro

Divers

Thread ID:

01098831

Message ID:

01099221

Vues:

>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--