Comments by Oviya Sivakumar

Oviya Sivakumar 11-Mar-20 3:48am View

Deleted

Even when i give a compiled css (which is given below )it doesnot makes any changes in the effects,when i click the button the action is not performed

Oviya Sivakumar 2-Jan-20 0:44am View

it works thank you

Oviya Sivakumar 30-Dec-19 6:01am View

i had tried
select e.first_name,e.last_name,format(e.hire_date,'%M %d %y') as 'Hire date' from employees e;

it shows
Truncated incorrect INTEGER value: '%M %d %y'

Oviya Sivakumar 30-Dec-19 5:47am View

when i tried the following

select concat(e.first_name," ",e.last_name)as 'employee name',format(s.salary*1.15,'C2') as 'No.Of Dollors'
from employees e
join salaries s
on e.emp_no=s.emp_no group by e.emp_no,s.emp_no;
it shows
Truncated incorrect INTEGER value: 'C2'

Oviya Sivakumar 30-Dec-19 5:45am View

Deleted

if i use
select concat(e.first_name," ",e.last_name)as 'employee name',format(s.salary*1.15,'C2') as 'No.Of Dollors'
from employees e
join salaries s
on e.emp_no=s.emp_no group by e.emp_no,s.emp_no;

though throws an error Truncated incorrect INTEGER value: 'C2'

Oviya Sivakumar 30-Dec-19 5:28am View

select concat(e.first_name," ",e.last_name)as 'employee name',format(s.salary*1.15,'$99,999','EN-US') as 'No.Of Dollors'
from employees e
join salaries s
on e.emp_no=s.emp_no group by e.emp_no,s.emp_no;

though its shows same error as
Truncated incorrect INTEGER value: '$99,999'
and
Unknown locale: 'EN-US'

Oviya Sivakumar 30-Dec-19 5:09am View

select concat(e.first_name," ",e.last_name)as 'employee name',format(1.15*s.salary,'$99999') as 'No.Of Dollors'
from employees e
join salaries s
on e.emp_no=s.emp_no group by e.emp_no,s.emp_no;

Oviya Sivakumar 30-Dec-19 4:45am View

i hv also given format(1.15*s.salary,'$99,999') though its showing same error as truncated integer value:'$99999'

Oviya Sivakumar 30-Dec-19 4:35am View

i had used format() instead of char (),though its showing same error as truncated incorrect integer value

Comments by Oviya Sivakumar (Top 9 by date)