4.31 date - Year Month Day

Format: date( $time$ )

Extract 8-digit fixed length string of Year Month Day (YYYMMDD) from $time$ .

Example

Example 1: Basic Example

$ more dat1.csv
id,time
1,20000101000000
2,20121021111213
3,
4,19770812122212
$ mcal c='date($t{time})' a=rsl i=dat1.csv o=rsl1.csv
#END# kgcal a=rsl c=date($t{time}) i=dat1.csv o=rsl1.csv
$ more rsl1.csv
id,time,rsl
1,20000101000000,20000101
2,20121021111213,20121021
3,,
4,19770812122212,19770812