PROCEDURE CONVERSION

[jrc1]

I am looking at converting the following Oracle procedcures to function in MS SQL Server 7. Any thoughts would be greatly appreciated.

begin-procedure Convert-date-to-ora-mmddyy
begin-select on-error=SQLerror
to_date($conv_dt,'MMDDYY') &ora_date
from dual
end-select
end-procedure

begin-procedure Convert-date-to-ora-yymmdd
begin-select on-error=SQLerror
to_date($conv_dt,'YYMMDD') &ora_date_YYMMDD
from dual
end-select
end-procedure

 

[tlbroadbent]

Convert current date to various formats in SQL Server.
[tt]
Format SQL
mm/dd/yy select convert(char(8),getdate(),1)
mm/dd/yyyy select convert(char(8),getdate(),101)
mmddyy replace(select convert(char(8),getdate(),1),'/','')
mmddyyyy replace(select convert(char(8),getdate(),101),'/','')
yy/mm/dd select convert(char(8),getdate(),11)
yyyy/mm/dd select convert(char(8),getdate(),111)
yymmdd select convert(char(8),getdate(),13)
yymmdd select convert(char(8),getdate(),113)[/tt] Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes