Real Software Forums
http://forums.realsoftware.com/

SOLVED Pervasive DB Date Type returns Time too - how to
http://forums.realsoftware.com/viewtopic.php?f=3&t=47307
Page 1 of 1

Author:  tseyfarth [ Sat Mar 16, 2013 7:24 pm ]
Post subject:  SOLVED Pervasive DB Date Type returns Time too - how to

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

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/