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.

“It works on my machine.” - Anonymous