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
"BlogSpot" Blogs Cannot Be Shared, Using "www"
-
We're seeing a number of reports from blog owners, claiming their blogs are
now subject to security alerts - and blocked when sharing.
Frequently, the repo...
5 years ago
No comments:
Post a Comment