Converting the current date to a number in SQL

IBM i 1 Minute

This is handy if you find yourself needing to populate a numeric timestamp field (eight digit number, yyyymmdd) with the current date.

update TheFile                                                
set TheDate = Dec(Replace(Char(current date, ISO), '-', ''), 8, 0)
where TheSelection

Obviously, TheFile is the file you are populating, TheDate is the field and TheSelection is whatever selection criteria you happen to be using.

Published by Paul

Reader of books, watcher of films, player of games. British father of three, now living in Belgium and making a living from building interfaces.

Published