/ Published in: SQL
![](/img/icon_sav.png?v3)
intfield has this format: YYYYMMDD
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT DATE(substr(CHAR(intfield), 1, 4) || '-'|| substr(CHAR(intfield),5, 2) || '-'|| substr(CHAR(intfield), 7, 2)) AS datefield FROM file1
Comments
![RSS Feed for Comments RSS Icon](/images/rss.png?v3)