Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
Try this:
Time(If(Len(Trim(TimeField)) = 0, 0, TimeField), 'hh:mm:ss')
Try this:
Time(If(Len(Trim(TimeField)) = 0, 0, TimeField), 'hh:mm:ss')
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
Something like this?
IF (ISNULL(mytimefield), MAKETIME(0,0,0), mytimefield) AS mytimefield