At 12:10 PM -0400 8/13/07, Puneet Bagoria wrote: >Hi All, > >Ingres stores date as "39272.383" , how can I convert it to standard date format? It doesn't, actually. Where is this format coming from? What Ingres version, and how are you retrieving the date? It looks like you might have been using the interval function somehow. Karl