Re: How to display DATE field in date format (from DB)
alter session set NLS_DATE_FORMAT='DD.MM. HH24:MI:SS';
select TO_DATE('1970-01-01 00:00:00', '-MM-DD hh24:mi:ss') +
numtodsinterval(c6, 'SECOND') from t954 where rownum 2;
Kind Regards
Torsten Brosow
Senior Solution Consultant
Column Technologies Australia Pty Ltd
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kali Obsum
Sent: Tuesday, 6 April 2010 11:59
To: arslist@ARSLIST.ORG
Subject: [ARSLIST] How to display DATE field in date format (from DB)
**
Hi,
We have a field of type 'DATE'. It is stored as an integer in DB. Does
anyone know how to display this in Date format? (e.g. are there
functions that we can use?)
Regards,
Kali
NOTICE
The information contained in this email is confidential. If you are not
the intended recipient, you must not disclose or use the information in
this email in any way. If you received it in error, please tell us
immediately by return email and delete the document. We do not guarantee
the integrity of any e-mails or attached files and are not responsible
for any changes made to them by any other person.
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
Hi, It's a Sybase DB. But we've figured it out. Thanks!:) Regards, Kali -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tristan Roppel Sent: Tuesday, 6 April 2010 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: How to display DATE field in date format (from DB) Kali Obsum schrieb: ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Hi, If this is an Oracle DB, you can use Oracle's time functions in PL/SQL function to calculate the date from an integer value. The exact function can i send you later ! Cheers Tristan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
Hi, Please look to the Database reference. Here you have the instruction for all supported database. Cheers Konrad TopPositions Really only one secure Plugin SSO for BM Remedy AR System. Http://www.remedy-sso.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, April 06, 2010 3:59 AM To: arslist@ARSLIST.ORG Subject: How to display DATE field in date format (from DB) ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
If your DB is SQL, then use this function:- set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER function [dbo].[fn_Convert_Date_HMS](@i int) returns datetime as begin return (Select DATEADD(second, @i+19800,'19700101')) end Thanks Regards, Rambabu Rudra System Administrator _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, April 06, 2010 7:29 AM To: arslist@ARSLIST.ORG Subject: How to display DATE field in date format (from DB) Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
Hi, Please look to the Database reference. Here you have the instruction for all supported database. Cheers Konrad TopPositions Really only one secure Plugin SSO for BM Remedy AR System. Http://www.remedy-sso.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, April 06, 2010 3:59 AM To: arslist@ARSLIST.ORG Subject: How to display DATE field in date format (from DB) ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to display DATE field in date format (from DB)
Kali Obsum schrieb: ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Hi, If this is an Oracle DB, you can use Oracle's time functions in PL/SQL function to calculate the date from an integer value. The exact function can i send you later ! Cheers Tristan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
