I have a field called stage the values is in hours I want to convert to seconds ? how can I do this?
Stage (in hrs)
I tried : stage*3600 as stage it is not giving the result?
Try with second(stage) or second(stage*3600) as stage
May be this
Time(Time#(Stage, 'h'), 'ss') as Stage_Seconds
or Num(Stage) * 3600
thanks sunny I tried secondone
Retrieving data ...