Home » SQL & PL/SQL » SQL & PL/SQL » max length of the date function
max length of the date function [message #248527] Fri, 29 June 2007 07:00 Go to next message
muddasani.s
Messages: 10
Registered: June 2007
Junior Member

hi

can any one tell me the max length if the date function
default is 8 is it correct ?
if not give me the right ans...

thx
Re: max length of the date function [message #248531 is a reply to message #248527] Fri, 29 June 2007 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no date function.

Regards
Michel
Re: max length of the date function [message #248537 is a reply to message #248527] Fri, 29 June 2007 07:46 Go to previous messageGo to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

If you want an answer for Max length of Date Datatype, It has only range and not Max length.
Re: max length of the date function [message #248540 is a reply to message #248537] Fri, 29 June 2007 08:00 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
As Michel says, there is no Date function, however, I am sure that you were trying to simply ask what is the length of a date.
If so, then try using Dump()for example:

SQL> select dump(to_date('10-Jan-2007','dd-mon-yyyy')) conv, dump(sysdate) sysdte, dump(hire_date) tabdte
  2  from employees
  3  where rownum =1;

CONV                                SYSDTE                              TABDTE
----------------------------------- ----------------------------------- -----------------------------------
Typ=13 Len=8: 215,7,1,10,0,0,0,0    Typ=13 Len=8: 215,7,6,29,14,0,18,0  Typ=12 Len=7: 119,199,6,21,1,1,1

[Updated on: Fri, 29 June 2007 08:01]

Report message to a moderator

Previous Topic: Working with Dates in Oracle
Next Topic: SQL query problem
Goto Forum:
  


Current Time: Wed Dec 07 07:02:57 CST 2016

Total time taken to generate the page: 0.06923 seconds