Posted By

wnasich on 11/12/11

Tagged

Viewed 2855 times

Favorited by 0 user(s)

/ Published in: SQL

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

Comment:

You need to login to post a comment.