timestamp_format problem

vivek.vivek · #1 (**permalink**) 01-27-09, 10:01

Help me to convert the timestamp, where am passing it as an input value (format : 12/7/2007 00:00:00)in procedure

'CREATE VIEW DBO.Step45_Flap1 AS
select * from (
select time_stamp,
' || CHAR(query1) ||',ROW_NUMBER() OVER (ORDER BY time_stamp DESC)
as RN from '||Param5||'
where time_stamp '||CHAR(Param4)||' TIMESTAMP_FORMAT(Param3,''MM-DD-YYYY HH24:MIS''))group by time_stamp)';

Thanks in Advance
Vivek

nick.ncs · #2 (**permalink**) 01-27-09, 21:07

shouldn't ''MM-DD-YYYY HH24:MIS'' be 'YYYY-MM-DD HH24:MIS'

vivek.vivek · #3 (**permalink**) 01-27-09, 23:07

But my input date format is MM/DD/YYYY
I changed that to YYYY-MM-DD. But is showing error in time format

nick.ncs · #4 (**permalink**) 01-28-09, 00:26

the problem is not with MM DD YYYY.... check the hour:min:second format
it should be
HH24 : MI : SS (without the spaces of course else it'll turn to a smiley

)
and not HH24:MIS

Internet Services

Web Development

Digital Marketing

Consumer Tech