Timestamp Format

Discussion created by mmorris1984 on Sep 21, 2009
Latest reply on Sep 22, 2009 by michaelh

Is there a way to modify the format of the timestamps that come out of PI-OLEDB queries?  I am using MATLAB to process and validate data that have been stored in PI and MATLAB cannot reproduce the M/D/YYYY type of timestamp that results from my queries.  FWIW, it defaults to S/M/2009 (as 'M' is interpreted as 'the first letter of the month', and 'D' is interpreted as 'the first letter of the name of the day').  I would like to, if possible, have the date strings represented in MM/DD/YYYY format (e.g. 09/21/2009). 




Thanks in advance for any help you can provide.