Date converting
in [Visual Objects]
|
Prev: Vulcan or Cavo 2.8 ?
Next: VO & Ado
From: Arne Ortlinghaus on 16 Apr 2008 05:02 Hello Frank, May be these are the milliseconds since1.1.1970. With Oracle I have made the following test: select to_date ('2008-04-15', 'YYYY-MM-DD') - (1208194275921 / 86400000) z from dual gives 1970-01-01 06:28:44 Arne Ortlinghaus "Frank" <frank_muessner(a)gmx.de> schrieb im Newsbeitrag news:d121f35f-feb0-43cf-aaf5-2f1a31257056(a)t54g2000hsg.googlegroups.com... I don�t know. It is from a Java App. that Export a XML File. So far as i know, the Date in this Sample 15.04.2008 Frank On 16 Apr., 08:12, John Martens <adsl672...(a)tiscali.nl> wrote: > Frank, > > What date should it be ? > > John > > Frank schreef: > > > > > Hi all, > > > how can I convert this Dateformat: > > <date value="1208194275921" /> > > > into the real Date an Time? > > > Thanks Frank M- Zitierten Text ausblenden - > > - Zitierten Text anzeigen -
From: Stephen Quinn on 16 Apr 2008 05:39 Frank >where I can found GetDateFromXML ? There is no function called that, it's an example - you'd need to extract the date from your XML file/field with whatever your using to read/parse the XML file. All I was showing is that by changing the date formats you can read it in using one format change the format and write it out in another. After reading your first post again I see that your actual data in the file looks like <date value="1208194275921" /> then what I showed isn't what you want. The date is probably UTC or GMT format (no. seconds since sometime in the past) which has Date and Time components. There are functions available to convert the data from that number into a datetime value. A search of MSDN points to - http://msdn2.microsoft.com/en-us/library/5hh873ya.aspx which should get you started. -- CYA Steve
From: Frank on 16 Apr 2008 06:59 Thanks for the help, the Format is milliseconds from 01.01.1970. I look for an Method, but nothing found. So I must write my own logik. Frank On 16 Apr., 11:39, "Stephen Quinn" <stevej...(a)SPbigpond.AMnet.au> wrote: > Frank > > >where I can found GetDateFromXML ? > > There is no function called that, it's an example > - you'd need to extract the date from your XML file/field with whatever your using to read/parse the XML file. > > All I was showing is that by changing the date formats you can read it in using one format change the format and write > it out in another. > > After reading your first post again I see that your actual data in the file looks like > > <date value="1208194275921" /> > > then what I showed isn't what you want. > > The date is probably UTC or GMT format (no. seconds since sometime in the past) which has Date and Time components. > > There are functions available to convert the data from that number into a datetime value. > A search of MSDN points to -http://msdn2.microsoft.com/en-us/library/5hh873ya.aspxwhich should get you started. > > -- > CYA > Steve
From: Werner Perplies on 16 Apr 2008 07:12 Frank, Am Wed, 16 Apr 2008 03:59:12 -0700 (PDT) schrieb Frank: > Thanks for the help, > > the Format is milliseconds from 01.01.1970. > I look for an Method, but nothing found. So I must write my own logik. Perhaps Days(Seconds) and TString(Seconds) can help? > > Frank > Werner -- German phpBB-Board for Visual Objects user: http://www.weepee.eu/forum/vo/ divUtilies: new version 14th June, 2006 http://www.weepee.eu/vo/DivUtilities/DivUtilities.zip
From: Tony Holland on 16 Apr 2008 08:40
Hi Frank, I think what you have is a Julian Date format. JD is the number of days elapsed since 01/01/4712BC Check on Google - lots of info Tony |