Query by date

oracle United States
  • 13 years ago

    Hi Guys,

    I am using Oracle 9i as backend and  C# ASP.NET 2.0. Could you please help me that how can I find out  list of users who logged in from date 2006/3/5 till 2007/23/2? I am looking for SQL statement for finding the list of logged users within that date. I have column name logged_date with DATE  as datatype in oracle.

    I would appreciate your help.





  • 13 years ago
    Hi Sthauttam
     This query may solve your problem.

     Select user_name From tblUser Where logged_date between '03/May/2006' And '23/Feb/2007'

    Good Luck

    Hari K......

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer lets you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila” - Mitch Ratcliffe