msecond サンプル1
入力データ
| 顧客 | 日付&時刻1 | 日付&時刻2 |
|---|---|---|
| customer1 | 19900111101600 | 19900111101500 |
| customer1 | 19900203221012 | 19900203221010 |
| customer1 | 19900522000001 | 19900521235959 |
| customer1 | 19900111101500 | 19900111101600 |
| customer1 | 19900111101600 | * |
| customer1 | * | 19900111101500 |
| customer1 | * | * |
処理コマンド
msecond field1=2 field2=3
結果データ
| 顧客 | 日付&時刻1 | 日付&時刻2 | 経過秒数 |
|---|---|---|---|
| customer1 | 19900111101600 | 19900111101500 | 60 |
| customer1 | 19900203221012 | 19900203221010 | 2 |
| customer1 | 19900522000001 | 19900521235959 | 2 |
| customer1 | 19900111101500 | 19900111101600 | -60 |
| customer1 | 19900111101600 | * | * |
| customer1 | * | 19900111101500 | * |
| customer1 | * | * | * |