1 Select To_Char(Trunc(Datetime) + (Trunc((Datetime - Trunc(Datetime)) *48) / 48), 'dd/Mm/Yy Hh:Mi') As Datetime
2 , Count(*)
3 From Ext_Ittbl1
4 Group By To_Char(Trunc(Datetime) + (Trunc((Datetime - Trunc(Datetime)) *48) / 48), 'dd/Mm/Yy Hh:Mi')
5* Order By To_Char(Trunc(Datetime) + (Trunc((Datetime - Trunc(Datetime)) *48) / 48), 'dd/Mm/Yy Hh:Mi')
SQL> /
Group By To_Char(Trunc(Datetime) + (Trunc((Datetime - Trunc(Datetime)) *48) / 48), 'dd/Mm/Yy Hh:Mi')
*
ERROR at line 4:
ORA-01722: invalid number
How to get URL of commentator
-
We sometimes get questions about how to get the web address/URL of a
commentator in our blog. Blogger.com has not provided any way to do that.
However, the...
7 years ago
No comments:
Post a Comment