| Author |
Message
|
| SOLOHERO |
 Posted: Mon Apr 02, 2007 9:13 pm Post subject: ESQL DATE |
 |
|
Centurion
Joined: 01 Feb 2007
Posts: 107
|
Hi,
How to set a date function Null in ESQL.
sy.Id.ptre:Status.core:EndDate=? (I want this Field to check if it is null or not)
_________________
Thanks |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Apr 02, 2007 9:17 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi SOLOHERO,
COALESCE.
Regards. |
|
| Back to top |
|
|
| SOLOHERO |
| Posted: Mon Apr 02, 2007 9:21 pm Post subject: |
|
|
Centurion
Joined: 01 Feb 2007
Posts: 107
|
Hi,
How can i use coalesce here , does that check the condition to null ,
I think it does put only default values.
_________________
Thanks |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Mon Apr 02, 2007 9:48 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi SOLOHERO,
I'm not sure what you want to do if the filed/value is null...
You should be working around COALESCE and NULLIF.
Regards. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Mon Apr 02, 2007 10:20 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
if u just want to check for it being NULL u can use IF condition with IS NULL clause
_________________
Cheers |
|
| Back to top |
|
|
| SOLOHERO |
| Posted: Tue Apr 03, 2007 1:14 am Post subject: |
|
|
Centurion
Joined: 01 Feb 2007
Posts: 107
|
Hi,
Thanks Guys i was studip i am not thinking is NULL i had before it was showing some error i thought it iwas this and i raised a quest.
Thanks for your Help anyways.
_________________
Thanks |
|
| Back to top |
|
|
|
|
