Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySql problem

 
colin shuker
Ranch Hand
Posts: 750
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, its not really a java problem, but its needed in a program I'm doing.

Using mysql 5.1(in windows xp) locally, I can't get to_timestamp(...) function to work.

If I enter on the MySql command prompt:


It just tells me I have an error in the syntax, but I know it works with oracle, and I'm pretty sure the to_timestamp is valid in mysql.

Can anyone help? Thanks
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it a valid MySQL function? I don't see it in the documentation (I had a quick glance under date/time fucntions - it might be somewhere else).
 
colin shuker
Ranch Hand
Posts: 750
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well I took off the to_ bit, and now it says:

Truncated incorrect time value: 'YYYY-MM-DD HH24:MI:SS'

So I guess I'm half way there, but can't seem to fix this
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic