Date format

Hi, I have given access to a new user “mbe” on the database. He is getting a different date format All user: Day, Month, Year User MBE: Month, Day, Year Can u tell me where in db do I change the default date format for this user? Thanks in advance.

Set the environment variable DBDATE in the users profile. This is within the Operating System and not within the database. So if its UNIX then it will be the user .profile or whatever its called in your flavour. > To: ids@iiug.org > From: ksushants@gmail.com > Subject: Date format [23005] > Date: Wed, 9 Mar 2011 04:38:01 -0500 > > Hi, > > I have given access to a new user “mbe” on the database. He is getting a > different date format > > All user: Day, Month, Year > > User MBE: Month, Day, Year > > Can u tell me where in db do I change the default date format for this user? > > Thanks in advance. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Just to add to what was said you are looking at something like this for a unix / unix like platform DBDATE=dmy4/export DBDATE The 4 specifies that your year will include the century and the / is the delimiter between the date parts Regards Mark > To: ids@iiug.org > From: agrantha@hotmail.com > Subject: RE: Date format [23006] > Date: Wed, 9 Mar 2011 04:54:13 -0500 > > Set the environment variable DBDATE in the users profile. This is within the > Operating System and not within the database. So if its UNIX then it will be > the user .profile or whatever its called in your flavour. > > > To: ids@iiug.org > > From: ksushants@gmail.com > > Subject: Date format [23005] > > Date: Wed, 9 Mar 2011 04:38:01 -0500 > > > > Hi, > > > > I have given access to a new user be?on the database. He is getting a > > different date format > > > > All user: Day, Month, Year > > > > User MBE: Month, Day, Year > > > > Can u tell me where in db do I change the default date format for this user? > > > > Thanks in advance. > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

DBDATE environment variable. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 9, 2011 at 4:38 AM, SUSHANT KODE <ksushants@gmail.com> wrote: > Hi, > > I have given access to a new user “mbe” on the database. He is getting a > different date format > > All user: Day, Month, Year > > User MBE: Month, Day, Year > > Can u tell me where in db do I change the default date format for this > user? > > Thanks in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e649d5de192496049e0f4d70