×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Have you tried working with TIMESTAMP_FORMAT or TO_DATE?
https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0007107.html
Sent from my iPhone
On Apr 17, 2019, at 9:14 AM, "dlclark@xxxxxxxxxxxxxxxx<mailto:dlclark@xxxxxxxxxxxxxxxx>" <dlclark@xxxxxxxxxxxxxxxx<mailto:dlclark@xxxxxxxxxxxxxxxx>> wrote:
CAUTION: EXTERNAL EMAIL
**********************************************************************
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> wrote on 04/17/2019
09:36:22 AM:
In SQL, how can I detect a NULL returned by a function like DATE() or
DEC()?
This is my statement:
select storagedt, ifnull(dec(date(storagedt)), 0) as "as Decimal" from
mytable
What if you reversed that to the following?
dec(ifnull(date(storagedt), 0))
Sincerely,
Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300
Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331
*********************************************************************************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary
information. If you have received this message in error, please
immediately notify the sender and delete and destroy the message and all
copies. All unauthorized direct or indirect use or disclosure of this
message is strictly prohibited. No right to confidentiality or privilege
is waived or lost by any error in transmission.
*********************************************************************************************
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=kUT9u1ftLjMzSSPm_-knDdNvxOshAnRL8kekFKxW3Wg&r=9Ntyfp-OuZH8yZaiXsb9HlYdW65WTi1eFGJS7ZM5Mok&m=5XX4gzGjzYhznrUhWXc688GI3o1IeADRgtHZgE1V0rM&s=28L0dH8XYS6fcHveDg-IPuLWyrKUVXKJLvHZZey8Wac&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=kUT9u1ftLjMzSSPm_-knDdNvxOshAnRL8kekFKxW3Wg&r=9Ntyfp-OuZH8yZaiXsb9HlYdW65WTi1eFGJS7ZM5Mok&m=5XX4gzGjzYhznrUhWXc688GI3o1IeADRgtHZgE1V0rM&s=-gCTizsRXPqVrroBMrWfe9AdrwLjO1zuF76gdcEL1TE&e=.
Please contact support@xxxxxxxxxxxx<mailto:support@xxxxxxxxxxxx> for any subscription related questions.
Help support midrange.com<
http://midrange.com> by shopping at amazon.com<
http://amazon.com> with our affiliate link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwICAg&c=kUT9u1ftLjMzSSPm_-knDdNvxOshAnRL8kekFKxW3Wg&r=9Ntyfp-OuZH8yZaiXsb9HlYdW65WTi1eFGJS7ZM5Mok&m=5XX4gzGjzYhznrUhWXc688GI3o1IeADRgtHZgE1V0rM&s=2GRSqnnaV_qmh_zHKraPTACnwoSfvM8UnDr_hcSofl0&e=
midrange.com
