[Lazarus-es] trabajando con horas

[christian Ortiz]

>
> Select
>  Cast(secs/3600 - 0.499999999999 as INTEGER) as Hours,
>  Cast((secs - Cast(secs/ 3600 - 0.499999999999 as INTEGER)*3600)/ 60 -
> 0.499999999999 as INTEGER) as Minutes,
>  secs- (Cast(secs/3600 - 0.499999999999 as INTEGER)*3600+Cast((secs -
> Cast(secs/ 3600 - 0.499999999999 as INTEGER)*3600)/ 60 - 0.499999999999 as
> INTEGER)*60) as Seconds
>  from (
> select SUM(TIME_FIELD - cast('0:0' as time)) as secs
> from TTABLE )
>
> Se tiene que hacer tanta cosa en Firebird???? ya se que motor de bd no debo
usar ....


> --
> Best regards,
>  José
>
>
> _______________________________________________
> Lazarus-es mailing list
> Lazarus-es en lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus-es
>



-- 
Christian
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus-es/attachments/20101017/a01cc833/attachment-0002.html>