Re: [WebDNA] Need to convert unix date?

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104161
interpreted = N
texte = Try this: [format days_to_date %m/%d/%Y][format .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format] On 12/15/2009 3:47 PM, David Bastedo wrote: > Hi, I need to convert a date stored in unix format - seconds since Jan > 01, 1970. Is there a formula or function that anybody might have? > > I am pulling in an xml file generated by an external api and that date > comes in this format. > > thanks. > > d. > > > -- > David Bastedo > Ten Plus One Communications Inc. > http://www.10plus1.com > T. 416.603.2223 > M. 416.277.4499 Associated Messages, from the most recent to the oldest:

    
  1. Fwd: [WebDNA] Need to convert unix date? (William DeVaul 2011)
  2. Re: [WebDNA] Need to convert unix date? (Donovan Brooke 2009)
  3. Re: [WebDNA] Need to convert unix date? (Donovan Brooke 2009)
  4. Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
  5. Re: [WebDNA] Need to convert unix date? (christophe.billiottet@webdna.us 2009)
  6. Re: [WebDNA] Need to convert unix date? (Govinda 2009)
  7. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  8. Re: [WebDNA] Need to convert unix date? ("Terry Wilson" 2009)
  9. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  10. Re: [WebDNA] Need to convert unix date? (Stuart Tremain 2009)
  11. Re: [WebDNA] Need to convert unix date? (Brian Fries 2009)
  12. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  13. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  14. Re: [WebDNA] Need to convert unix date? (Bob Minor 2009)
  15. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  16. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  17. Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
  18. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  19. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  20. Re: [WebDNA] Need to convert unix date? (Marc Thompson 2009)
  21. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  22. Re: [WebDNA] Need to convert unix date? (David Bastedo 2009)
  23. Re: [WebDNA] Need to convert unix date? (Dan Strong 2009)
  24. [WebDNA] Need to convert unix date? (David Bastedo 2009)
Try this: [format days_to_date %m/%d/%Y][format .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format] On 12/15/2009 3:47 PM, David Bastedo wrote: > Hi, I need to convert a date stored in unix format - seconds since Jan > 01, 1970. Is there a formula or function that anybody might have? > > I am pulling in an xml file generated by an external api and that date > comes in this format. > > thanks. > > d. > > > -- > David Bastedo > Ten Plus One Communications Inc. > http://www.10plus1.com > T. 416.603.2223 > M. 416.277.4499 Dan Strong

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Reversing [ipaddress] normalization (1998) Frustration with formulas.db (1999) Week # problem (1998) Re1000002: Setting up shop (1997) Setting Lineitems (2005) Anomaly ? causes NT application event log to overflow (1997) Targeted Redirect (1999) WebCat for Unix?? (1997) Setting up shop (1997) Image maps/Webcat (1997) Comments in db? (1997) [WebDNA] WebDNA on PowerPC Leopard Server (2009) Database Repopulation (2004) Secure server question (1997) Not reading code (1997) [purchase] (1999) IP lookup tool via tcpconnect (2002) 2 databases (1998) [WebDNA] ImageMagick troubleshooting (2009) WebCat2b13MacPlugIn - [showif][search][/showif] (1997)