select * from employee where empdate BETWEEN DATE

Hi!
I’m doing one Project in vb.net 2008 using mysql .In that
Project have the following Issues..
1.if one Employee getting Salary 1.2 lacs / annum means ..
After he getting 1st month Salary i want to show remaining
11 month salary.. How can i Create Trigger for this Problem
& How can i use it..

Question Posted / ram gopal verma

1 Answers
3198 Views
I also Faced
E-Mail Answers

Answer Posted / ram gopal verma

select * from employee where empdate BETWEEN DATE_FORMAT(NOW(), '%Y-01-%d') AND DATE_FORMAT(NOW() ,'%Y-05-%d')

Note- I u want (%Y-01-%d) means show February month to (%Y-05-%d) June months.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we create table in stored procedure?

1003

What is max connections in mysql?

994

Why do we use pragma autonomous transaction?

960

How to define numeric 9(3) in db2 table without decimal point??

2901

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2283

How to install mysql?

1065

How do I disable mysql?

994

How to convert character strings to dates?

1143

What is trigger in mysql with example?

969

What is different between sql and mysql?

1070

Is mysqli secure?

939

Can we store images in mysql database?

948

Can mysql scale horizontally?

1034

What is the current mysql version?

1070

How can we run batch mode in mysql?

1127