dd-mm-yy [message #373416] |
Mon, 16 April 2001 09:27 |
Damon
Messages: 7 Registered: April 2001
|
Junior Member |
|
|
hi everyone!
i need to create view with date column where date format is 'dd-mm-yy'i've tried many times but all dates which stored into my view form the table stored in dd-mon-yy format...what should i do??
sorry for bad english...
|
|
|
Re: dd-mm-yy [message #373419 is a reply to message #373416] |
Mon, 16 April 2001 10:09 |
Damon
Messages: 7 Registered: April 2001
|
Junior Member |
|
|
8),but i'm not such a fool..this is my code and it doesn't work
CREATE OR REPLACE VIEW date_view
(masterthingid,value,title,context_url,
description )
AS
select wwv_things.masterthingid,to_date(wwv_thingattributes.value,'dd.mm.yy'),
title,context_url,description
from wwv_things,wwv_thingattributes where subtypeattributeid=1841
and wwv_thingattributes.value<>'00.00.00'
and wwv_things.masterthingid=wwv_thingattributes.masterthingid order by to_date(wwv_thingattributes.value,'dd.mm.yy') asc
|
|
|
|