New topic: 

SOLVED Pervasive DB Date Type returns Time too - how to

<http://forums.realsoftware.com/viewtopic.php?t=47307>

         Page 1 of 1
   [ 1 post ]                 Previous topic | Next topic          Author  
Message        tseyfarth          Post subject: SOLVED Pervasive DB Date Type 
returns Time too - how toPosted: Sat Mar 16, 2013 7:24 pm                       
  
Joined: Sat Dec 04, 2010 9:14 pm
Posts: 852                Hello All,

**Sorry all, this was an error on my part SQL was returning properly **


When I retrieve data from a date field, i get  both date and time.  This is 
actually only supposed to be a date field (btrieve days). However the SQL 
command retrieve both the Date and some trailing Time information too.  How do 
I tell the SQL engine to only give the date part?

Also, the time is returned as AM/PM.  How do I change to 24 hour clock?

Thank you,
Tim   
                             Top             Display posts from previous: All 
posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost 
timeSubject AscendingDescending          Page 1 of 1
   [ 1 post ]      
-- 
Over 1500 classes with 29000 functions in one REALbasic plug-in collection. 
The Monkeybread Software Realbasic Plugin v9.3. 
http://www.monkeybreadsoftware.de/realbasic/plugins.shtml

[email protected]

Reply via email to