Re: Need a short directive

2014-10-08 Thread Trianon 33
A big thanks to Johan, who pointed me in the right direction. I had indeed to fix a where clause, but in the end al went very well. BR, hans. Johan De Meersman schreef op 07-10-14 om 16:10: - Original Message - From: "Trianon 33" Subject: Need a short directive V

Re: Need a short directive

2014-10-07 Thread Trianon 33
Thanks, later on I'm going to try this, will post results here. Bye, Hans. Johan De Meersman schreef op 07-10-14 om 16:10: - Original Message - From: "Trianon 33" Subject: Need a short directive Values from yearanddate look like this: 2013-12-11 00:00:00. I want to

Re: Need a short directive

2014-10-07 Thread Johan De Meersman
- Original Message - > From: "Trianon 33" > Subject: Need a short directive > > Values from yearanddate look like this: 2013-12-11 00:00:00. I want to That's only a display format; internally it's an integer (well, presumably a struct time_t) count

Need a short directive

2014-10-07 Thread Trianon 33
All, Normallu just lurking, but as a newbie with MYSQL looking for a direction for this issue: I have a table with a filed called year, integre, 5 positions. I have another field in the same table called yearanddate, which has a date format. Values from yearanddate look like this: 2013-12-1