jk
شنبه 16 مرداد 1389, 13:22 عصر
In SQL:
Select Cast(MinuteValue / 60 as Varchar) + ':' + Cast(MinuteValue % 60 as Varchar) From myTable
In Access:
SELECT Trim(Str(CInt(MinuteValue/60))) + ':' + Trim(Str(CInt(MinuteValue mod 60)))
FROM myTable
Select Cast(MinuteValue / 60 as Varchar) + ':' + Cast(MinuteValue % 60 as Varchar) From myTable
In Access:
SELECT Trim(Str(CInt(MinuteValue/60))) + ':' + Trim(Str(CInt(MinuteValue mod 60)))
FROM myTable