mkarthik415
asked on
help with mysql query
I need records of the employees who joined today and I am using this query
select * from emp where join_date between '2010-01-07 00:00:00' AND '2010-01-07 23:59:59'
I need help to change this query such that I don't have to manually change the date every day
select * from emp where join_date between '2010-01-07 00:00:00' AND '2010-01-07 23:59:59'
I need help to change this query such that I don't have to manually change the date every day
select * from emp where join_date = trunc(sysdate)
In asp:
dim start_date
dim end_date
start_date = year(now)&"-"&month(now)&" -"&day(now )&" "&hour(now)&":"&minute(now )&":"&seco nd(now)
end_date = year(now)&"-"&month(now)&" -"&day(now )&" 23:59:59"
select * from emp where join_date between "&start_date&"' AND '"&end_date&"'
dim start_date
dim end_date
start_date = year(now)&"-"&month(now)&"
end_date = year(now)&"-"&month(now)&"
select * from emp where join_date between "&start_date&"' AND '"&end_date&"'
ASKER
when using
select * from emp where join_date = trunc(sysdate)
I am getting error 'trunc does not exist'
select * from emp where join_date = trunc(sysdate)
I am getting error 'trunc does not exist'
what programming language are you using?
is not oracle???
in mysql try this...
select * from emp where join_date = CURDATE();
in mysql try this...
select * from emp where join_date = CURDATE();
ASKER
The programming language I am using is java.
What is the database you are working on ?
ASKER
My database is MySql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TY