Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Daniel Hofford
  Where is Daniel Hofford?
 Ocala
 Florida - United States
 Daniel Hofford
 Tags
Subject: RE: DATETIME()
Thread ID: 189004 Message ID: 189016 # Views: 2 # Ratings: 1
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, August 13, 2008 12:28:31 AM         
   


> Is there a function to pull the time from DATETIME()?
> If the datetime() is 12/05/07 03:01:02 PM I need 15:01:02
> or if its 10:15:03 AM I need 10:15:03. With a lot of parsing I can do it - just wondering if someone has written a function for it as I'm being a bit lazy here.
>
> Thanks
>
> Dan
> "Our gold does not chink and glitter. It gleams in the sun and neighs in the dark." Chief Joseph

Since you needed only the time portion without the AM/PM, then you need to add more to what Andy has given u:

?LEFT(TTOC(DATETIME(),2),8)


or

?LEFT(TIME(DATETIME()),8)


Another is to go to the 24-hour formatting (military) so that AM/PM is no longer needed:

SET HOUR TO 24
?TTOC(DATETIME(),2)



Jun Tangunan

"Get out of the past and look in the future."
http://weblogs.foxite.com/sandstorm36/

ENTIRE THREAD

DATETIME() Posted by Daniel Hofford @ 8/12/2008 10:57:18 PM
RE: DATETIME() Posted by Andy Kramek @ 8/12/2008 11:00:46 PM
RE: DATETIME() Posted by Daniel Hofford @ 8/13/2008 12:58:18 AM
RE: DATETIME() Posted by Andy Kramek @ 8/13/2008 11:54:50 AM
RE: DATETIME() Posted by Jun Tangunan @ 8/13/2008 12:28:31 AM
RE: DATETIME() Posted by Daniel Hofford @ 8/13/2008 12:58:53 AM
RE: DATETIME() Posted by Jun Tangunan @ 8/13/2008 2:49:26 AM
RE: DATETIME() Posted by Cetin Basoz @ 8/13/2008 12:23:39 PM
RE: DATETIME() Posted by Yousfi Benameur @ 8/13/2008 12:59:24 PM