|
| check system date with variable |
 |
Tue, 11 Mar 2008 08:27:47 +000 |
Hello everybody.......
I want to use '>' and '<' on two datetime variables. Is it possible ? if
yes
Please help with example
|
| Post Reply
|
| Re: check system date with variable |
 |
Tue, 11 Mar 2008 08:57:53 +000 |
What do you mean by I want to use '>' and '<'
|
| Post Reply
|
| Re: check system date with variable |
 |
Fri, 14 Mar 2008 14:20:18 +000 |
Maybe you need to ask your question a little bit in more detail. But yes, it's
possible:
AND orderDate > STR_TO_DATE(?, '%Y-%m-%e') AND orderDate < STR_TO_DATE(?,
'%Y-%m-%e')
This is assuming you get your date to compare to as a String input.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|