|Drstroker||if i select a row that has a date in it such as YYYY-MM-DD how would i convert that in the sql?|
|vice-versa||Drstroker: convert it to what?|
|Drstroker||oh sorry a different date format|
say month day year
|tupa||uhm HOUR(mytime) ??|
|tupa||Drstroker, maybe I didn't understand what you are trying to do|
|Xgc||Drstroker: or try DATE_FORMAT()|
|Drstroker||Xgc: hey how ya doing!|
oh i got a real challege for ya now lol
i have wanna see if this is possible, i have two tables, one table has a birthday, the other has a 1 or 0 in a column, now i want to retrieve the birthday as bday if the table has a 1 if it has a 0 i want bday to contain the string "Perfer not to say"
how possible is this in mysql?
actually i already have a soultion lol now i'm just curious
|vice-versa||Drstroker: what was your solution?|
|Drstroker||i was just going to pull both in a simple join and just use php and an if statement that if it is a 1 display it '|
i was just wondering if i could do it in pure mysql
|vice-versa||if( showbday, Date_Format(birthday, '%d/%e/%Y'), 'Perfer not to say') as bday|
|action||vice-versa smacks Drstroker upside the head with a MySQL cookbook ;)|
|vice-versa||smacks Drstroker upside the head with a MySQL cookbook ;)|
|ToeBee||ah yeah I guess an if works too. but CASE is similar :)|
case showbday when 1 then birthday else 'Prefer to not say' end
|the_wench||The_wench taps her fingers.......|
|Drstroker||please explain i am not following|
i can't seem to get Date_Format(dob, '%b/%e/%Y') to work ...
nevermind damn comma
|StuBo||can you write your own routines in mysql...to use in queries|
like a sum( or count( but obvoisly there already available
|ToeBee||!man stored procedures|
|StuBo||can you use them in queries though....to caclulte values ?|
|Ahilyla||someone can tell me how to use mysqlbinlog to show only a specific User...|
|StuBo||select thedate from Customer Where customerAge = MyFunc()|
can I do that ToeBee ?
|ToeBee||I would assume so but I haven't actually used stored procedures myself|
|Drstroker||nice this works good !!! awesome thanks|