Toad World® Forums

Date to 2-byte binary

I was wondering if anyone knows how to do the following:

Perform date arithmetic for a given date ‘YYYYMMDD’ say, from Jan 1, 1940, in order

to create a 2-byte binary representation to send back to a mainframe?

Even I do not fully understand the question, maybe you should place that question on Oracle SQL/PLSQL forum.

Are you trying to get the number of days since a specified anchor date, as an integer? If so, that’s easy:

NUM_DAYS := DATE_TO_CONVERT – TO_DATE(‘19400101’,’YYYYMMDD’)

Nate Schroeder

US Row Crops IT Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WB - Saint Louis, MO - 63167

314-694-2592

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Tuesday, February 11, 2014 9:26 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Date to 2-byte binary

RE: Date to 2-byte binary

Reply by damir.vadas_531

Even I do not understand the question, have suggestion to ask that on Oracle SQL forum.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled

to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and

all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.

All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its

subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of “Viruses” or other “Malware”.

Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying

this e-mail or any attachment.

The information contained in this email may be subject to the export control laws and regulations of the United States, potentially

including but not limited to the Export Administration Regulations (EAR) and sanctions regulations issued by the U.S. Department of

Treasury, Office of Foreign Asset Controls (OFAC). As a recipient of this information you are obligated to comply with all

applicable U.S. export laws and regulations.