Home » SQL & PL/SQL » SQL & PL/SQL » Format date?
Format date? [message #268285] Tue, 18 September 2007 02:07 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi


Can anybody tellthis syntax meaning

formatdate(todate(formatnumber((sysdate);"00")
Re: Format date? [message #268291 is a reply to message #268285] Tue, 18 September 2007 02:18 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
What application are you using?
Re: Format date? [message #268302 is a reply to message #268285] Tue, 18 September 2007 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not Oracle.
Note that this is an Oracle forum.

Regards
Michel
Re: Format date? [message #268320 is a reply to message #268285] Tue, 18 September 2007 03:10 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Quote:

formatdate(todate(formatnumber((sysdate);"00")


Do you please supplied us the original SQL Statement.
Re: Format date? [message #268399 is a reply to message #268302] Tue, 18 September 2007 07:47 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Michel Cadot wrote on Tue, 18 September 2007 03:42
This is not Oracle.



It's not Oracle and surely there can't be any language/database/etc. that accepts unbalanced parenthesis as such. Well, maybe a Microsoft product.
Previous Topic: Query
Next Topic: Performace of CLOBs in table.
Goto Forum:
  


Current Time: Sat Dec 03 16:15:36 CST 2016

Total time taken to generate the page: 0.08808 seconds