Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Mon Jul 16, 2018 4:06 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: SOLVED Pervasive DB Date Type returns Time too - how to
PostPosted: Sat Mar 16, 2013 7:24 pm 
Offline

Joined: Sat Dec 04, 2010 9:14 pm
Posts: 918
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
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group