Solved

[microwin88x]

Solved

[sunny_talwar · Accepted solution]

Try this:

Time(If(Len(Trim(TimeField)) = 0, 0, TimeField), 'hh:mm:ss')

[its_anandrjs]

Share a sample file or you can do some think this ways

  LOAD *,if(IsNull(Col) = -1 or Len(Col)=1,'00:00:00',Col) as Chk;
load * Inline
[
Col
12:10:34
10:12:34
01:23:45
-
23:12:28
11:34:49
];

Regards

Anand

[roger_stone]

Something like this?

IF (ISNULL(mytimefield), MAKETIME(0,0,0), mytimefield) AS mytimefield