getting last 2 months date..but dont have datefield in table

Hi groups,
I forget to declare datefield in my employee table...but now in implementati
on stage...my customer is asking me to list the last two months inserted dat
e from employee table. How i can get the last 2 months inserted rows from a
table which is not having a datefield/time..
Is there any hidden data say inserted datetime etc for each rows ...?
please suggest
--
Mhsh Kumr. R> Is there any hidden data say inserted datetime etc for each rows ...?
No, unless you have a backup from two months ago and can compare it to
today's data...|||Hi
You will not have this information anywhere.
You can tell ur customer that it needs a fix and introduce a new column with
timestamp field atleast now.
u can update the timestamp with previous date or current date.
Or u might be having employee join date, u can fetch data based on that
please let me know if you would like to know anything else
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Maheshkumar.R" wrote:

> Hi groups,
> I forget to declare datefield in my employee table...but now in implementation s
tage...my customer is asking me to list the last two months inserted date from emplo
yee table. How i can get the last 2 months inserted rows from a table which is not h
avi
ng a datefield/time..
> Is there any hidden data say inserted datetime etc for each rows ...?
'
> please suggest
> --
> M?hésh Kum?r|||> introduce a new column with
> timestamp field atleast now.
Just to clarify, DATETIME or SMALLDATETIME (not the poorly-named TIMESTAMP
data type).|||No, no, no. "Time stamp field" is actually a less known painting by Dali.
ML