Created date

system · June 5, 2003, 7:19pm

Is there any way to find our the creation date of a particular user?

peacock (BOB member since 2002-11-07)

system · June 5, 2003, 7:30pm

If you search for “created user date” you should get your answer.

JennFisher (BOB member since 2002-06-25)

system · June 5, 2003, 8:02pm

This is what you are looking for.

BO_User (BOB member since 2002-10-02)

system · June 5, 2003, 8:16pm

Thanks guys. But i am getting the number 1,024,762,234.00. When i try to format it, I am not getting the correct date, time format.

peacock (BOB member since 2002-11-07)

system · June 5, 2003, 8:18pm

digpen:

You can “convert” it back to a date via:
to_date('15-DEC-1970','DD-MON-YYYY') + (m_actor_n_lad/86400) 
86400 being the number of seconds in a day (606024).

I believe the Date (Dec 15, 1970) was chosen arbitrarily as a date that would fit as a 32-bit value that would allow the greatest range for second-based calculations.

See also this thread: M_ACTOR_N_LAD - how figure out date?

Andreas (BOB member since 2002-06-20)

system · June 5, 2003, 8:39pm

I am not able to use formula like that. It’s giving #ERROR. I don’t konw what’s wrong in my values. One thing I am using the formula in REPORTER. Do I have to use it in the DESIGNER. Any sugesstions?

peacock (BOB member since 2002-11-07)

system · June 5, 2003, 9:11pm

You have to use this in designer. May have to change it if you are not using Oracle db.

reemagupta (BOB member since 2002-09-18)

system · June 6, 2003, 12:01pm

My repository tables are in MS Sql Server. when I try to use convert function I am getting arithmetic overflow error message.

peacock (BOB member since 2002-11-07)

system · June 6, 2003, 12:37pm

Now it’s working fine. Used Cast function in MS Sql Server

peacock (BOB member since 2002-11-07)

system · September 9, 2003, 4:13pm

FYI,

For the SQL Server users, you can use:


SELECT	dateadd(s,(@BOTIME), '15-dec-1970')

Where @BOTIME is the field you want to convert. You could also wrap it in a function for easy use with:


CREATE FUNCTION bo.BoDate (@BOTIME int) 
	RETURNS DATETIME
AS
BEGIN
	RETURN (
		SELECT	dateadd(s,(@BOTIME), '15-dec-1970')
		)
END

That way you can simply select a field with the function, i.e. :


SELECT bo.BODate(M_REPO_N_CREATDATE) FROM bo.OBJ_M_REPOSITORY

Regards,

Dan Lelovic

dl_toronto (BOB member since 2002-08-28)