#mysql - Thu 17 May 2007 between 18:16 and 18:26

NY Lost Funds



Leithal| DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS('1979-01-22')), '%Y')+0 |
+----------------------------------------------------------------------+
| 28 |
sl00or days.
pos69sumi have an array of record ids that i want to store in a database, what's the best way to store this array - as a string, then explode the array when i read it back from the db?
henke37a year is always the same ammount of secs
unless there is fricition in space
snoyesa calendar year is not.
seekwillsl00: But you don't care about that level of precision anyways
Leithaleven in a leap year? :)
actionsnoyes thinks we should discard the whole leap year concept and make Dec. 31 only last until 6 in the morning.
snoyesthinks we should discard the whole leap year concept and make Dec. 31 only last until 6 in the morning.
or add a Dec 32, or whatever is necessary
sl00henke37: No they are not. Leapyears.
p_mashonewbie question. I want to get bacl a list of duplicate "code" columns in my tabe.. trying >> select prod_id, count(code) as c , distinct(code) from products
group by prod_id order by c desc << but it dont work. I trying to find duplicates
snoyesdupes
the_wenchfind them with select count(dupefield) as qty,otherfields from table group by dupefield having qty >1
sl00seekwill: I would not ask if I did not need the precision.
actionp_masho ROFL at the_wench's nick !!!
p_mashoROFL at the_wench's nick !!!
snoyes!beer p_masho
beer p_masho
c'mon, one of those
archivist: little help?
seekwill!wench beer snoyes
the_wenchHere snoyes have a cool beer
henke37leapyears does not afect the astronomical orbit time
snoyesaha
seekwillsl00: You only want how many whole years. There is going to be a SMALL window where the number will be incorrect. I'm sure you can play the chances.
actionseekwill goes to do something funnnner
seekwillgoes to do something funnnner
p_mashothe_wench: lovely lovely... ta
henke37play the chances?
at least calcualte the max error
Leithalsl00: I swear I just posted a solution
henke37then you can talk about taking chances
Leithalcan't believe you are still going on about it :P
sl00Not if you are sending congrats cards.
The network connection is messed up. Must have missed it :(
seekwilllol
fury_snoyes: how can I get root access to be accesible remotely?
Leithal| DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS('1979-09-22')), '%Y')+0 |

Page: 5 12 19 26 33 40 47 54 61 

IrcArchive

NY Lost Funds