reset password
Author Message
lakerfan94
Posts: 143
Posted 19:56 Oct 24, 2015 |

Regarding number 2 for homework 3, we're told to look for the number of parts that were ordered in June of "this year" but "this year" may not be assumed to be 2015. Then what years are we considering?

se1k1h1mawar1
Posts: 121
Posted 20:00 Oct 24, 2015 |

I thought we were to consider the current time of the query execution.
Am I wrong?

Last edited by se1k1h1mawar1 at 20:05 Oct 24, 2015.
raywu64
Posts: 44
Posted 20:05 Oct 24, 2015 |
se1k1h1mawar1 wrote:

I thought we were to consider the current time of the query execution.
Wrong?

This was my assumption as well. There is a built in "function" (if that's the right word) that gives the current date. 

lakerfan94
Posts: 143
Posted 20:14 Oct 24, 2015 |

@raywu64 You are right. We have to use the current date in some way, I forgot. Thanks.