Some Trials & a lot of Errors
I tried a bunch of framework and other language and I usually feel overwhelm when its time to do something real with what I've learned. So that why I created this site, to write my progress and help some noob like me that stumble into the sames problems.
Browse: Home / date

date

How to search by date in Oracle

By Chris on July 19, 2014

The to_date function we talked earlier make a come back. The wrong way to do it is : SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = ’12-04-27′ you end up comparing string in that case to work you need to do the following: SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = […]

Posted in db, prog | Tagged date, oracle, search, to_date | Leave a response

ORACLE Date won’t work with greater or lesser than operator

By Chris on July 12, 2014

I was having problem making one of my SQL query work in ORACLE until I realize that I got the check on the date wrong. It seem that Oracle didn’t interpreted my query has I expected when handling a date with a greater or lesser than operator (< or >). So this won’t work : […]

Posted in db | Tagged date, datetime, oracle, to_date | Leave a response

Tags

2018 2022 about app apparment arraylist blog book books condo date db errors gifts hibernate ideas inspiration java java.util.List jboss linux List mongodb MongoRepository MongoTemplate motivation mysql netstat oracle port productivity real estate reviews school Seth Godin sql String struts students The 100 days project The Practice to_date wedding welcome windows

Recent Comments

  • kevin on Oracle have no Boolean, how to fix this

Calendar

May 2022
MonTueWedThuFriSatSun
 1
2345678
9101112131415
16171819202122
23242526272829
3031 
« Apr  

Archives

  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • March 2021
  • February 2021
  • May 2020
  • January 2019
  • December 2018
  • July 2018
  • April 2018
  • January 2018
  • October 2014
  • September 2014
  • August 2014

Copyright © 2022 Some Trials & a lot of Errors.

Powered by WordPress and Hybrid.