Finding gaps or missing dates in a date range

Vlasdo's profile image Vlasdo posted 8 years ago in Running SQL scripts Permalink

Finding gaps or missing dates in a datee column ?

Table: ddtemperature

"Station" "Datee" "Valuee"

"14542" "2006-01-01 00:00:00" "1.8"

"14542" "2006-01-02 00:00:00" "2.7"

"14542" "2006-01-03 00:00:00" "2.5"

"14542" "2006-01-04 00:00:00" "1"

"14542" "2006-01-09 00:00:00" "1.9"

txt in attachmnet,

Thanks in advance.

1 attachment(s):
ansgar's profile image ansgar posted 8 years ago Permalink

I am normally doing such stuff with PHP. Any other scripting language you are just using is good enough for that.

Please login to leave a reply, or register at first.