A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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
I agree. Here's the link:
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