473,654 Members | 3,074 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Time and date in sql

1 New Member
I have a project in Isql*plus database.In this project I have to get names for Employees who started work in the first half of the year(01 january to June 30 th)...I'm stuck..please help
=============== =============== =============== =============== ==
Here is my Algorithm:
select last_name,Hire_ date,Department _ID
from employees
where ??????????????? ??????????????? ????????
what can i put where there are ??????????????
Nov 9 '11 #1
2 1718
Rabbit
12,516 Recognized Expert Moderator MVP
Assuming hire_date is a datetime field and not char.
Expand|Select|Wrap|Line Numbers
  1. hire_date between '01/01/2011' and '06/30/2011'
Nov 9 '11 #2
anuradha22
1 New Member
select * from scott.emp where hiredate between '01-jan-1981' and '01-jun-1981';


For More queries http://www.yellowpen.co.in/oracle_No...s/Queries.html
Nov 9 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
7144
by: Shaiboy_UK | last post by:
Hi All, Sorry if this is the wrong newsgroup to post into, on this topic, if so, please point me in the right direction..... Currently working on a ASP for a friend, which requires the date and time on it. It pulls in entries from an Access Database with dates and times in the format of: "Fri Oct 17 18:02:46 2003" However my date and time on the ASP page is displayed as:
3
3391
by: Roel Castro | last post by:
Hello everyone, Could somebody help me how to open time/date item in Control panel by codes in access form modules? Taking in consideration the operating system which is Windows 98, Windows 2000 and windows XP.
4
2636
by: qtip | last post by:
I have a simple table the has First Name , Last Name, SSN, Date&Time. I have a report that will show all this information but I would like to put in at calculation to tell the difference between 2 Date&time stamps for the person. The report shows Last name, First Name and Date&Tiem Field. If the persone has 2 records I would like to show the amount of time between each in put.
9
3220
by: Bob Achgill | last post by:
I would like to use the timestamp on files to manage the currency of support files for my VB windows application. In this case I would only put the timestamp of the file in the management database and not the file itself. To do this I will need to have a File class property for Create time and date that will let me "set" the Create time and date of the file to my own chooseing. The VB file class does not appear to have the ability
8
4549
by: bessie | last post by:
I have a registration form that loads into a dava.csv file (code below). I want to add a time/date stamp so that each time someone registers, the last column in the spreadsheet shows the time/date. I've tried several things but all have failed and the form stops working. I'm taking classes this fall on programming but need to do this now, unfortunately. Any help? :confused: <?php @extract($ POST); if(is_writable('data.csv')) { $fp =...
9
3026
by: Jackson1 | last post by:
I am new to access and have created a database. I have created a couple of fields Date/ Time of Call Date and Time of placement Date and time of procedure I need to calculate the differance between Date and time of initial call Differance between Date / Time of placement Differance between Date/ Time of procedure. Times are in 2:30:00 PM and 14: 30 formats.
1
1548
by: tulikapuri | last post by:
Friends , i want to chart the data from report for on daily, weekly and monthly basis and i have three variable i.e. time , date and Moisture. Can someone guide me how to arroach this issue, its simply driving me nuts.
3
2292
by: climber | last post by:
Hello, I am attemping to append a memo box or text box with a time/date stamp. What I would like to happen is either when I click a button the time/date stamp prints below what is already typed into the text box or it prints automatically below the entered text when I click on the text box in order to make changes to the text box Ex. Hello how are you! 6/5/07 1:15:00 I am fine!
12
5558
by: skyy | last post by:
Hi.. I am working on Arm-linux os on developement board. The OS reset the time and date whenever the board is reset. Is there any way that i can run a script to set the time/date instead of manually setting it? Thanks..
1
1347
by: thesti | last post by:
hi, i'm new to php. how to show the time / date, a message is posted. like in forums, there are something like, "5 minutes ago", "8 hourse 17 minutes ago", "Yesterdar", "10-07-2008". in every post. thanks
0
8290
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8815
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8708
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7307
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6161
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5622
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4149
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4294
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2716
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.