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
Printable View
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) AS Hour From myTable