• 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
Re: Zero dates "0000-00-00"
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Zero dates "0000-00-00"


  • Subject: Re: Zero dates "0000-00-00"
  • From: Andrew Lindesay <email@hidden>
  • Date: Wed, 18 Mar 2009 09:08:59 +1300

Hello;

For the reason that some date functions in MySQL return strings, I created a class which can be used as a "data type" in the modeller and which (from memory) handles this scenario if you are having to deal with timestamps-as-strings;

	LEEONSTimestampFromMySQLString

This may help if Lachlan's suggestion does not work although I think for cases where real zero-timestamps exist, this does work.

cheers.

Is there some known hint to get rid with exception raised when dealing
with zero dates in SQL?
I'm taking data from database maintained with a third party program.

___ Andrew Lindesay www.lindesay.co.nz

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Zero dates "0000-00-00" (From: Gennady Kushnir <email@hidden>)
 >Re: Zero dates "0000-00-00" (From: Lachlan Deck <email@hidden>)

  • Prev by Date: Re: Zero dates "0000-00-00"
  • Next by Date: Re: Zero dates "0000-00-00"
  • Previous by thread: Re: Zero dates "0000-00-00"
  • Next by thread: Re: Zero dates "0000-00-00"
  • Index(es):
    • Date
    • Thread