This week's book giveaway is in the
We're giving away four copies of a choice of
"Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac"
and have Joe Kissell on-line!
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Take Control of Upgrading to Yosemite
Take Control of Automating Your Mac
this week in the
Joined: Oct 09, 2003
Jan 24, 2005 13:47:00
I have tried to run my current web application with Oracle Server.
, i have faced a problem on date and time type in Oracle as compared to MySQL.
Date Time Format in MySQL
-> yyyy-MM-dd hh:mm:ss eg.1983-09-05 13:28:00
TimeStamp Format in Oracle
-> dd-MMM-yy hh.mm.ss eg.09-SEP-05 13.28.00
How do i convert this timestamp format to mysql format?
God Gave Me Nothing I Wanted<br />He Gave Me Everything I Needed<br /> - Swami Vivekananda
Joined: Feb 05, 2001
Jan 24, 2005 15:40:00
Hmm, tough to figure out if this is a Java question or an Oracle SQL questions.
In Java, there are
classes that can parse one date(
) and then format it into a new one date(string).
In Oracle, there is the to_char() which takes a date, and a format and returns a String in that format. Is there a to_date(). Sheesh, no SQL coding in almost a year and see what you forget.
Perfect World Programming, LLC
Two Laptop Bag
How to Ask Questions the Smart Way FAQ
subject: Need Help
ORA-01861: literal does not match format string
DB2 Date format to Oracle Date format?
Problem computing time based on TimeZones
Date comparision in SQL from timestamp
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014