/
generalizeDate

generalizeDate

Return "$date$" if a string is a date format; otherwise return the input string. Useful for log obfuscation.

Usage Details

LQL Command

select generalizeDate(column) as resultCol from table

Example

Input
table

date
2017-04-11T04:32:51Z
2017

LQL command

select *, generalizeDate(date) as a resultCol from table

Output

date resultCol
2017-04-11T04:32:51Z$date$
20172017

Related content

generalizeLong
generalizeLong
More like this
generalizeInt
generalizeInt
More like this
Format date (formatdate)
Format date (formatdate)
More like this