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)
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)
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)
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"
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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"