Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Daniel Hofford
  Where is Daniel Hofford?
 Ocala
 Florida - United States
 Daniel Hofford
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: DATETIME()
Thread ID: 189004 Message ID: 189021 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, August 13, 2008 12:58:53 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/

See Andy's message to me.

Thanks

Dan
"Our gold does not chink and glitter. It gleams in the sun and neighs in the dark." Chief Joseph

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