hi sir, id like to ask how can i filter a users log in if he's first time in is 6:00am and he leaves at 3:00pm and then he came for work again on same day which is 10pm until the next day. how can i get the 2 timein of the user? thanks.
Great video. I am new to sql queries and have to find a way to do a query where I return results that occurred between the time of 06:00 and 18:00 each day, no matter what the date is. My date/time field is called open_time and is for trouble tickets. I want to only find tickets opened during the hours of 6a to 6pm. How might I build a query?
it was really useful thank you so much!! but what if i want to remove Date from Time? should i replace >>> Where CAST( hire_date As Date ) with this >>> Where CAST (hire_date As Time)?? thank you so much i really appreciate it!
Hi Joey Blue, what if one person has 2 hire dates ? How can we filter one person with only one date ? Max function is not effective. Could you suggest an alternative ?
Great vid! Simple to understand and concise, and appreciate the datetime code examples too. Thanks!
Great Job! Thank You!
Great Video!
Very nice and informative - thx.
Excellent, thank you very much
Convert(date,hiredate,103)
Wiil provide same output
can you please share same video for Oracle as oracle dont have any datediff function ,thanks for the video
Many thanks, you helped me fix my problem :-)
Dear sir , excellent sir , thanks thanks very very thanks sir
hi sir, id like to ask how can i filter a users log in if he's first time in is 6:00am and he leaves at 3:00pm and then he came for work again on same day which is 10pm until the next day. how can i get the 2 timein of the user?
thanks.
Wow, you are awesome!!!!!!!!!
Great video. I am new to sql queries and have to find a way to do a query where I return results that occurred between the time of 06:00 and 18:00 each day, no matter what the date is. My date/time field is called open_time and is for trouble tickets. I want to only find tickets opened during the hours of 6a to 6pm. How might I build a query?
can you please share how you completed this query if you did so. I need to do something very similar
@@wadebouley9240 Did you completed this query ?. I also have to do something similar.
great job!!!!!
How would you just get the year?
Thank you!
Sir , how to print data from date to date?
it was really useful thank you so much!!
but what if i want to remove Date from Time?
should i replace >>> Where CAST( hire_date As Date )
with this >>> Where CAST (hire_date As Time)??
thank you so much i really appreciate it!
Hi Joey Blue, what if one person has 2 hire dates ? How can we filter one person with only one date ?
Max function is not effective.
Could you suggest an alternative ?
How can i filter data only by their time range (hours) if the date is automatic (GetDate)
Hi, I keep getting an incorrect syntax error near the < sign.
how can i do this same thinks using nodjes bookshelf.
can you tell me type of hire_date
what if i try to find employees those who r hired in January or any other months?? :/
How can we get the files
THANKS