|Real Software Forums
|SOLVED Pervasive DB Date Type returns Time too - how to
|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|
**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?
|Page 1 of 1||All times are UTC - 5 hours|
|Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group