Welcome Guest, Not a member yet? Register   Sign In
need to find all records with 2009 from a date string of XX/XX/XXXX
#12

[eluser]jedd[/eluser]
[quote author="Flying Fish" date="1250302247"]this might sound so lazy, but I just dont get the whole mysql time stamp thing, and what I need is not so mission critical that it merits spending a lot of time on

looking at dates that make sense is so much easier for me[/quote]

Note that for about 96% of humans, the date format you're using doesn't make any sense. At least with the MSB approach - as described by ISO8601, and as used by MySQL in its various DATE fields - the problem you're now having .. doesn't happen.

It might be worth the time (I'd guess about 10 minutes of reading) as I reckon it'll save you from other troubles in the future.


Messages In This Thread
need to find all records with 2009 from a date string of XX/XX/XXXX - by El Forum - 08-14-2009, 03:25 PM



Theme © iAndrew 2016 - Forum software by © MyBB