What I really need to do is find a way to covert DOY to a date.

Kale Abhishek wrote:
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as normal
> **Anything below this line is the original email text
>
>
> Hi Joanna,
>
> I am not sure if you have a DB2 function to create a timestamp out of
> DOY, YEAR and TIME.
> I think you can create a function on your own with the below SQL
> select cast(current date as char(10)) || cast ('-' as char) ||
> cast(current time as char(8)) || cast ('.' as char) || cast ('000000' as
> char (6))
> as Time_stamp from sysibm.sysdummy1
>
> This query will return ZEROES in the nano seconds part of the timestamp.
>
> Please let me know if this helps.
>
> Regards,
> Abhishek.
>
> -----Original Message-----
> From: Joanna Grossman
> [Email address protected]
> Sent: Friday, March 21, 2008 1:53 AM
> To: LazyDBA Discussion
> Subject: creating a timestamp
>
> Is there a function to create a timestamp from a DOY, YEAR, and a TIME?
>
> JG
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> -----Message Disclaimer-----
>
> This e-mail message is intended only for the use of the individual or
> entity to which it is addressed, and may contain information that is
> privileged, confidential and exempt from disclosure under applicable law.
> If you are not the intended recipient, any dissemination, distribution or
> copying of this communication is strictly prohibited. If you have
> received this communication in error, please notify us immediately by
> reply email to [Email address protected] and delete or destroy all copies of
> the original message and attachments thereto. Email sent to or from the
> Principal Financial Group or any of its member companies may be retained
> as required by law or regulation.
>
> Nothing in this message is intended to constitute an Electronic signature
> for purposes of the Uniform Electronic Transactions Act (UETA) or the
> Electronic Signatures in Global and National Commerce Act ("E-Sign")
> unless a specific statement to the contrary is included in this message.
>
> While this communication may be used to promote or market a transaction
> or an idea that is discussed in the publication, it is intended to provide
> general information about the subject matter covered and is provided with
> the understanding that The Principal is not rendering legal, accounting,
> or tax advice. It is not a marketed opinion and may not be used to avoid
> penalties under the Internal Revenue Code. You should consult with
> appropriate counsel or other advisors on all matters pertaining to legal,
> tax, or accounting obligations and requirements.
>
>
>

--
joanna grossman
web & data manager
vermont monitoring coop
www.uvm.edu/vmc


DB2 & UDB email list listserv db2-l LazyDBA home page