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
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
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)
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
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)
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
6 matches
Mail list logo