• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
How to query a date in a MySQL database?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

How to query a date in a MySQL database?

  • Subject: How to query a date in a MySQL database?
  • From: Kitwana Akil <email@hidden>
  • Date: Fri, 25 Apr 2003 12:59:45 -0400
I have a model with a table that has the following column:

Attribute name: date
Value Class: NSCalendarDate
External Type:  Date

How do I search this column so that I can return results from a string enter for a search. For example:

User enters:  "Apr 21, 2003"

I want to return results based on all rows in the database that are equal to this date. Can someone explain how to convert the date into a form that I can use to query the database.

Kitwana
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
  • Follow-Ups:
    • Re: How to query a date in a MySQL database?
      • From: Ricardo Strausz <email@hidden>
  • Prev by Date: IllegalStateException: undo: undo manager is in invalid state - Huh?
  • Next by Date: Fetching Raw Rows
  • Previous by thread: IllegalStateException: undo: undo manager is in invalid state - Huh?
  • Next by thread: Re: How to query a date in a MySQL database?
  • Index(es):
    • Date
    • Thread