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

[eluser]jedd[/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]

It's just another data type - one that's convenient for storing time information. You should read up on DATETIME, DATE and TIMESTAMP field types (for MySQL).

You can set it (at creation, or any time subsequent) using SQL's NOW() function. But unless you change it intentionally, as with your VARCHARs, INTs, and so on - the content of that field won't change by itself.


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:56 PM



Theme © iAndrew 2016 - Forum software by © MyBB