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
Date comparision in SQL from timestamp
ORA-01861: literal does not match format string
DB2 Date format to Oracle Date format?
Problem computing time based on TimeZones
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014