topic Re: required info on timestamp in shell script in Operating System - Linux

required info on timestamp in shell script

Karthik_sg — Thu, 26 Jul 2007 01:28:07 GMT

hi all,
I have a field named timestamp in a tablei n mysql database.And its datatype is timestamp.for ex: the values in that field will look like, 2007-07-02 17:26:06

My question is this:i am accepting only date in my shell script as input.So do we need to enter the seconds also or just date will do.
If only date is the input how to check all the entries for that give date(since hours,mins and seconds changes rit).Pls do reply asap.Thnks in advance.

Re: required info on timestamp in shell script

Stuart Browne — Thu, 26 Jul 2007 06:32:14 GMT

A 'timestamp' field will quite happily just take a date. It will assume midnight of that day however.

Re: required info on timestamp in shell script

Karthik_sg — Thu, 26 Jul 2007 08:25:08 GMT

k.But it is incorrect rit.Because if it takes the midnight time,wht about the other time in the same day.So if i do a select * from table where date=27-01-2007 it wil just return one value.i.e, midnight time.The rest will be ignored.So how to go abt it.any other suggestions

Re: required info on timestamp in shell script

Stuart Browne — Thu, 26 Jul 2007 16:01:25 GMT

Oh. You want to retrieve data from the field..

Compare it against a date_format() that just looks at the month:

SELECT * FROM tbl WHERE DATE_FORMAT(timestamp_field, "%Y-%m-%d") = '2007-01-27';

You can manipulate the date order to be however you want at this point.

Re: required info on timestamp in shell script

Karthik_sg — Fri, 27 Jul 2007 02:12:00 GMT

k.Thnks,I wil let u know whtr it works or not.