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

[eluser]Jondolar[/eluser]
[quote author="Flying Fish" date="1250304526"]Maybe I could find some video training...will the mysql date field update every time you access the record or can it just be set once the first time the record was created[/quote]

The first timestamp field in a record will be updated with the current date/time every time a record is modified. No other field does this so you can use a datetime field without any problems.

If you do every decide to use a timestamp field and don't want the auto-update, you can create two timestamp fields and just use the second field while mysql updates the first one. This may have changed in newer versions. I don't use timestamp fields much any more.


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, 11:16 PM



Theme © iAndrew 2016 - Forum software by © MyBB