473,699 Members | 2,801 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle SQL query by date

vnl
I'm trying to run a SQL query but can't find any records when trying to
select a certain date. Here's the sql:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time = '01-SEP-02'

I'm getting no results. The date_and_time field is formatted like this:

2002-SEP-02 00:01:04

When I run a range, the results show that records do occur on the single
date that I am looking for:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time >= '01-SEP-02' and date_and_time <= '01-DEC-02'

I'm wondering whether the problem may have something to do with the date
field containing both the date and time. Any suggestions?

Thanks.
Jul 19 '05 #1
7 682742

"vnl" <vn****@vnl999. invalid> wrote in message
news:Xn******** ************@21 6.196.97.131...
I'm trying to run a SQL query but can't find any records when trying to
select a certain date. Here's the sql:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time = '01-SEP-02'

I'm getting no results. The date_and_time field is formatted like this:

2002-SEP-02 00:01:04

When I run a range, the results show that records do occur on the single
date that I am looking for:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time >= '01-SEP-02' and date_and_time <= '01-DEC-02'

I'm wondering whether the problem may have something to do with the date
field containing both the date and time. Any suggestions?

Thanks.

You are making the mistake of comparing a string to a date. Compare a date
to a date. '01-SEP-02' is a string , date_and_time is a date. Do it like:
SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time >=to_date( '01-SEP-02','dd-mmm-yy') and date_and_time
<= to_date('01-DEC-02','dd-mmm-yy');

You should really use 4 didgit years unless you really mean the year 2. So
it should be:
SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time >=to_date( '01-SEP-2002','dd-mmm-yyyy') and
date_and_time <= to_date('01-DEC-2002','dd-mmm-yyyy');

Jim
Jul 19 '05 #2
vnl <vn****@vnl999. invalid> wrote in message news:<Xn******* *************@2 16.196.97.131>. ..
I'm trying to run a SQL query but can't find any records when trying to
select a certain date. Here's the sql:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time = '01-SEP-02'

I'm getting no results. The date_and_time field is formatted like this:

2002-SEP-02 00:01:04

And here lies the problem. You date is not equal to '01-SEP-02', it has
time component as well. You can either include time in your query
condition:

WHERE date_and_time = to_date('2002-SEP-02 00:01:04', 'YYYY-MON-DD HH24:MI:SS')

or use trunc function to truncate date before comparing it to the constant:

WHERE trunc(date_and_ time) = '01-SEP-02'

When I run a range, the results show that records do occur on the single
date that I am looking for:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time >= '01-SEP-02' and date_and_time <= '01-DEC-02'

I'm wondering whether the problem may have something to do with the date
field containing both the date and time. Any suggestions?

Thanks.

Jul 19 '05 #3
vnl
af******@yahoo. com (Alex Filonov) wrote in
news:33******** *************** ***@posting.goo gle.com:
vnl <vn****@vnl999. invalid> wrote in message
news:<Xn******* *************@2 16.196.97.131>. ..
I'm trying to run a SQL query but can't find any records when trying
to select a certain date. Here's the sql:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time = '01-SEP-02'

I'm getting no results. The date_and_time field is formatted like
this:

2002-SEP-02 00:01:04


And here lies the problem. You date is not equal to '01-SEP-02', it
has time component as well. You can either include time in your query
condition:

WHERE date_and_time = to_date('2002-SEP-02 00:01:04', 'YYYY-MON-DD
HH24:MI:SS')

or use trunc function to truncate date before comparing it to the
constant:

WHERE trunc(date_and_ time) = '01-SEP-02'

When I run a range, the results show that records do occur on the
single date that I am looking for:

SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time >= '01-SEP-02' and date_and_time <= '01-DEC-02'

I'm wondering whether the problem may have something to do with the
date field containing both the date and time. Any suggestions?

Thanks.


Thanks everyone. The field did turn out to be a "date" type field.

I was eventually able to get it to work by using the following format:

SELECT field1, field2, date_and_time,
FROM table1
WHERE TRUNC(date_and_ time)=TO_DATE(' 31-dec-2002','dd-MON-yyyy')

What was weird was that I was getting different results in the
date_and_time field depending on whether I was running the SQL in Toad,
Oracle's SQL program (forgot name), and Crystal Reports SQL Designer. Two
showed both the date and time, the other showed just the date while
running the same SQL query. It got even worse as I tried to import the
data into Excel and Access which added further formatting decisions.

I'm still working on getting the SQL query to remove the time entirely so
that I will just have the date in that field.

Thanks.
Jul 19 '05 #4

"vnl" <vn****@vnl999. invalid> wrote in message
news:Xn******** ************@21 6.196.97.131...
| af******@yahoo. com (Alex Filonov) wrote in
| news:33******** *************** ***@posting.goo gle.com:
|
| > vnl <vn****@vnl999. invalid> wrote in message
| > news:<Xn******* *************@2 16.196.97.131>. ..
| >> I'm trying to run a SQL query but can't find any records when trying
| >> to select a certain date. Here's the sql:
| >>
| >> SELECT field 1, field2, date_and_time,
| >> FROM table1
| >> WHERE date_and_time = '01-SEP-02'
| >>
| >> I'm getting no results. The date_and_time field is formatted like
| >> this:
| >>
| >> 2002-SEP-02 00:01:04
| >>
| >
| > And here lies the problem. You date is not equal to '01-SEP-02', it
| > has time component as well. You can either include time in your query
| > condition:
| >
| > WHERE date_and_time = to_date('2002-SEP-02 00:01:04', 'YYYY-MON-DD
| > HH24:MI:SS')
| >
| > or use trunc function to truncate date before comparing it to the
| > constant:
| >
| > WHERE trunc(date_and_ time) = '01-SEP-02'
| >
| >
| >> When I run a range, the results show that records do occur on the
| >> single date that I am looking for:
| >>
| >> SELECT field 1, field2, date_and_time,
| >> FROM table1
| >> WHERE date_and_time >= '01-SEP-02' and date_and_time <= '01-DEC-02'
| >>
| >> I'm wondering whether the problem may have something to do with the
| >> date field containing both the date and time. Any suggestions?
| >>
| >> Thanks.
|
| Thanks everyone. The field did turn out to be a "date" type field.
|
| I was eventually able to get it to work by using the following format:
|
| SELECT field1, field2, date_and_time,
| FROM table1
| WHERE TRUNC(date_and_ time)=TO_DATE(' 31-dec-2002','dd-MON-yyyy')
|
| What was weird was that I was getting different results in the
| date_and_time field depending on whether I was running the SQL in Toad,
| Oracle's SQL program (forgot name), and Crystal Reports SQL Designer. Two
| showed both the date and time, the other showed just the date while
| running the same SQL query. It got even worse as I tried to import the
| data into Excel and Access which added further formatting decisions.
|
| I'm still working on getting the SQL query to remove the time entirely so
| that I will just have the date in that field.
|
| Thanks.
|
|

you're not really getting different results, the different tools are
displaying the results differently

oracle date columns are stared in an internal 7 byte binary format which is
not directly displayable, but always must be converted to a character format
by any tool that is attempting to display dates -- some tools, like TOAD,
choose their on date/time format for converting the data, others, like
SQL*Plus pick up the default format for the session, which is usually
DD-MON-RR

regarding working on removing the time entirely -- that's the better use of
the TRUNC function, in your select list. if you get in the habit of using
TRUNC in the WHERE clause, you may well end up writing poor some very poorly
performing code once you start working with production tables, since using
an expression on a column in the WHERE clause will prevent Oracle from using
any available index on that column, unless the index is a function-based
index (there are other considerations as to whether or not oracle will user
an index, but this is a typical performance error)

try rewriting the query so you don't have use TRUNC in the where clause --
this usually involves using a BETWEEN expression or a >= & < pair of
expressions; or, make sure you understand function based indexes

++ mcs
Jul 19 '05 #5
vnl
"Mark C. Stock" <mcstockX@Xenqu ery .com> wrote in
news:KK******** ************@co mcast.com:

"vnl" <vn****@vnl999. invalid> wrote in message
news:Xn******** ************@21 6.196.97.131...
| af******@yahoo. com (Alex Filonov) wrote in
| news:33******** *************** ***@posting.goo gle.com:
|
| > vnl <vn****@vnl999. invalid> wrote in message
| > news:<Xn******* *************@2 16.196.97.131>. ..
| >> I'm trying to run a SQL query but can't find any records when
| >> trying to select a certain date. Here's the sql:
| >>
| >> SELECT field 1, field2, date_and_time,
| >> FROM table1
| >> WHERE date_and_time = '01-SEP-02'
| >>
| >> I'm getting no results. The date_and_time field is formatted like
| >> this:
| >>
| >> 2002-SEP-02 00:01:04
| >>
| >
| > And here lies the problem. You date is not equal to '01-SEP-02', it
| > has time component as well. You can either include time in your
| > query condition:
| >
| > WHERE date_and_time = to_date('2002-SEP-02 00:01:04', 'YYYY-MON-DD
| > HH24:MI:SS')
| >
| > or use trunc function to truncate date before comparing it to the
| > constant:
| >
| > WHERE trunc(date_and_ time) = '01-SEP-02'
| >
| >
| >> When I run a range, the results show that records do occur on the
| >> single date that I am looking for:
| >>
| >> SELECT field 1, field2, date_and_time,
| >> FROM table1
| >> WHERE date_and_time >= '01-SEP-02' and date_and_time <=
| >> '01-DEC-02'
| >>
| >> I'm wondering whether the problem may have something to do with
| >> the date field containing both the date and time. Any suggestions?
| >>
| >> Thanks.
|
| Thanks everyone. The field did turn out to be a "date" type field.
|
| I was eventually able to get it to work by using the following
| format:
|
| SELECT field1, field2, date_and_time,
| FROM table1
| WHERE TRUNC(date_and_ time)=TO_DATE(' 31-dec-2002','dd-MON-yyyy')
|
| What was weird was that I was getting different results in the
| date_and_time field depending on whether I was running the SQL in
| Toad, Oracle's SQL program (forgot name), and Crystal Reports SQL
| Designer. Two showed both the date and time, the other showed just
| the date while running the same SQL query. It got even worse as I
| tried to import the data into Excel and Access which added further
| formatting decisions.
|
| I'm still working on getting the SQL query to remove the time
| entirely so that I will just have the date in that field.
|
| Thanks.
|
|

you're not really getting different results, the different tools are
displaying the results differently

oracle date columns are stared in an internal 7 byte binary format
which is not directly displayable, but always must be converted to a
character format by any tool that is attempting to display dates --
some tools, like TOAD, choose their on date/time format for converting
the data, others, like SQL*Plus pick up the default format for the
session, which is usually DD-MON-RR

regarding working on removing the time entirely -- that's the better
use of the TRUNC function, in your select list. if you get in the
habit of using TRUNC in the WHERE clause, you may well end up writing
poor some very poorly performing code once you start working with
production tables, since using an expression on a column in the WHERE
clause will prevent Oracle from using any available index on that
column, unless the index is a function-based index (there are other
considerations as to whether or not oracle will user an index, but
this is a typical performance error)

try rewriting the query so you don't have use TRUNC in the where
clause -- this usually involves using a BETWEEN expression or a >= & <
pair of expressions; or, make sure you understand function based
indexes

++ mcs


Would this be the correct format?:

SELECT field1, field2, TRUNC(date_and_ time),
FROM table1
WHERE date_and_time=T O_DATE('31-dec-2002','dd-MON-yyyy')
Thanks.
Jul 19 '05 #6

"vnl" <vn****@vnl999. invalid> wrote in message
news:Xn******** ************@21 6.196.97.131...
| "Mark C. Stock" <mcstockX@Xenqu ery .com> wrote in
| news:KK******** ************@co mcast.com:
|
| >
| > "vnl" <vn****@vnl999. invalid> wrote in message
| > news:Xn******** ************@21 6.196.97.131...
| >| af******@yahoo. com (Alex Filonov) wrote in
| >| news:33******** *************** ***@posting.goo gle.com:
| >|
| >| > vnl <vn****@vnl999. invalid> wrote in message
| >| > news:<Xn******* *************@2 16.196.97.131>. ..
| >| >> I'm trying to run a SQL query but can't find any records when
| >| >> trying to select a certain date. Here's the sql:
| >| >>
| >| >> SELECT field 1, field2, date_and_time,
| >| >> FROM table1
| >| >> WHERE date_and_time = '01-SEP-02'
| >| >>
| >| >> I'm getting no results. The date_and_time field is formatted like
| >| >> this:
| >| >>
| >| >> 2002-SEP-02 00:01:04
| >| >>
| >| >
| >| > And here lies the problem. You date is not equal to '01-SEP-02', it
| >| > has time component as well. You can either include time in your
| >| > query condition:
| >| >
| >| > WHERE date_and_time = to_date('2002-SEP-02 00:01:04', 'YYYY-MON-DD
| >| > HH24:MI:SS')
| >| >
| >| > or use trunc function to truncate date before comparing it to the
| >| > constant:
| >| >
| >| > WHERE trunc(date_and_ time) = '01-SEP-02'
| >| >
| >| >
| >| >> When I run a range, the results show that records do occur on the
| >| >> single date that I am looking for:
| >| >>
| >| >> SELECT field 1, field2, date_and_time,
| >| >> FROM table1
| >| >> WHERE date_and_time >= '01-SEP-02' and date_and_time <=
| >| >> '01-DEC-02'
| >| >>
| >| >> I'm wondering whether the problem may have something to do with
| >| >> the date field containing both the date and time. Any suggestions?
| >| >>
| >| >> Thanks.
| >|
| >| Thanks everyone. The field did turn out to be a "date" type field.
| >|
| >| I was eventually able to get it to work by using the following
| >| format:
| >|
| >| SELECT field1, field2, date_and_time,
| >| FROM table1
| >| WHERE TRUNC(date_and_ time)=TO_DATE(' 31-dec-2002','dd-MON-yyyy')
| >|
| >| What was weird was that I was getting different results in the
| >| date_and_time field depending on whether I was running the SQL in
| >| Toad, Oracle's SQL program (forgot name), and Crystal Reports SQL
| >| Designer. Two showed both the date and time, the other showed just
| >| the date while running the same SQL query. It got even worse as I
| >| tried to import the data into Excel and Access which added further
| >| formatting decisions.
| >|
| >| I'm still working on getting the SQL query to remove the time
| >| entirely so that I will just have the date in that field.
| >|
| >| Thanks.
| >|
| >|
| >
| > you're not really getting different results, the different tools are
| > displaying the results differently
| >
| > oracle date columns are stared in an internal 7 byte binary format
| > which is not directly displayable, but always must be converted to a
| > character format by any tool that is attempting to display dates --
| > some tools, like TOAD, choose their on date/time format for converting
| > the data, others, like SQL*Plus pick up the default format for the
| > session, which is usually DD-MON-RR
| >
| > regarding working on removing the time entirely -- that's the better
| > use of the TRUNC function, in your select list. if you get in the
| > habit of using TRUNC in the WHERE clause, you may well end up writing
| > poor some very poorly performing code once you start working with
| > production tables, since using an expression on a column in the WHERE
| > clause will prevent Oracle from using any available index on that
| > column, unless the index is a function-based index (there are other
| > considerations as to whether or not oracle will user an index, but
| > this is a typical performance error)
| >
| > try rewriting the query so you don't have use TRUNC in the where
| > clause -- this usually involves using a BETWEEN expression or a >= & <
| > pair of expressions; or, make sure you understand function based
| > indexes
| >
| > ++ mcs
| >
|
| Would this be the correct format?:
|
| SELECT field1, field2, TRUNC(date_and_ time),
| FROM table1
| WHERE date_and_time=T O_DATE('31-dec-2002','dd-MON-yyyy')
|
|
| Thanks.

in the select list, yes
but your where clause will only find rows for 12/31/02 that have no time
element stored in the date_and_time column
look at the between operator or look into using a '>=' along with a '<'
operator

++ mcs
Jul 19 '05 #7
vnl
"Mark C. Stock" <mcstockX@Xenqu ery .com> wrote in
news:Ob******** ************@co mcast.com:

"vnl" <vn****@vnl999. invalid> wrote in message
news:Xn******** ************@21 6.196.97.131...
| "Mark C. Stock" <mcstockX@Xenqu ery .com> wrote in
| news:KK******** ************@co mcast.com:
|
| >
| > "vnl" <vn****@vnl999. invalid> wrote in message
| > news:Xn******** ************@21 6.196.97.131...
| >| af******@yahoo. com (Alex Filonov) wrote in
| >| news:33******** *************** ***@posting.goo gle.com:
| >|
| >| > vnl <vn****@vnl999. invalid> wrote in message
| >| > news:<Xn******* *************@2 16.196.97.131>. ..
| >| >> I'm trying to run a SQL query but can't find any records when
| >| >> trying to select a certain date. Here's the sql:
| >| >>
| >| >> SELECT field 1, field2, date_and_time,
| >| >> FROM table1
| >| >> WHERE date_and_time = '01-SEP-02'
| >| >>
| >| >> I'm getting no results. The date_and_time field is formatted like| >| >> this:
| >| >>
| >| >> 2002-SEP-02 00:01:04
| >| >>
| >| >
| >| > And here lies the problem. You date is not equal to '01-SEP-02', it| >| > has time component as well. You can either include time in your
| >| > query condition:
| >| >
| >| > WHERE date_and_time = to_date('2002-SEP-02 00:01:04', 'YYYY-MON- DD| >| > HH24:MI:SS')
| >| >
| >| > or use trunc function to truncate date before comparing it to the
| >| > constant:
| >| >
| >| > WHERE trunc(date_and_ time) = '01-SEP-02'
| >| >
| >| >
| >| >> When I run a range, the results show that records do occur on the| >| >> single date that I am looking for:
| >| >>
| >| >> SELECT field 1, field2, date_and_time,
| >| >> FROM table1
| >| >> WHERE date_and_time >= '01-SEP-02' and date_and_time <=
| >| >> '01-DEC-02'
| >| >>
| >| >> I'm wondering whether the problem may have something to do with
| >| >> the date field containing both the date and time. Any suggestions?| >| >>
| >| >> Thanks.
| >|
| >| Thanks everyone. The field did turn out to be a "date" type field.
| >|
| >| I was eventually able to get it to work by using the following
| >| format:
| >|
| >| SELECT field1, field2, date_and_time,
| >| FROM table1
| >| WHERE TRUNC(date_and_ time)=TO_DATE(' 31-dec-2002','dd-MON-yyyy')
| >|
| >| What was weird was that I was getting different results in the
| >| date_and_time field depending on whether I was running the SQL in
| >| Toad, Oracle's SQL program (forgot name), and Crystal Reports SQL
| >| Designer. Two showed both the date and time, the other showed just
| >| the date while running the same SQL query. It got even worse as I
| >| tried to import the data into Excel and Access which added further
| >| formatting decisions.
| >|
| >| I'm still working on getting the SQL query to remove the time
| >| entirely so that I will just have the date in that field.
| >|
| >| Thanks.
| >|
| >|
| >
| > you're not really getting different results, the different tools are
| > displaying the results differently
| >
| > oracle date columns are stared in an internal 7 byte binary format
| > which is not directly displayable, but always must be converted to a
| > character format by any tool that is attempting to display dates --
| > some tools, like TOAD, choose their on date/time format for converting| > the data, others, like SQL*Plus pick up the default format for the
| > session, which is usually DD-MON-RR
| >
| > regarding working on removing the time entirely -- that's the better
| > use of the TRUNC function, in your select list. if you get in the
| > habit of using TRUNC in the WHERE clause, you may well end up writing| > poor some very poorly performing code once you start working with
| > production tables, since using an expression on a column in the WHERE| > clause will prevent Oracle from using any available index on that
| > column, unless the index is a function-based index (there are other
| > considerations as to whether or not oracle will user an index, but
| > this is a typical performance error)
| >
| > try rewriting the query so you don't have use TRUNC in the where
| > clause -- this usually involves using a BETWEEN expression or a >= & <| > pair of expressions; or, make sure you understand function based
| > indexes
| >
| > ++ mcs
| >
|
| Would this be the correct format?:
|
| SELECT field1, field2, TRUNC(date_and_ time),
| FROM table1
| WHERE date_and_time=T O_DATE('31-dec-2002','dd-MON-yyyy')
|
|
| Thanks.

in the select list, yes
but your where clause will only find rows for 12/31/02 that have no time element stored in the date_and_time column
look at the between operator or look into using a '>=' along with a '<'
operator

++ mcs


This is the code that I was eventually able to get working. Any
suggestions about making it better?

SELECT field1, field2, TO_CHAR(date_an d_time, 'DD-MON-YYYY') AS
date_entry
FROM table1
WHERE TRUNC(date_and_ time)=TO_DATE(' 01-sep-2002', 'DD-MON-YYYY')
I tried using trunc in the select clause and was getting weird results
.... The year was coming out as "0003" instead of "2003"

Thanks.
Jul 19 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
8956
by: sajid | last post by:
This is a treeview Root -- Cricket1 ---Cricket2 ---sachin --Cricket3 --dravid --FootBALL1
4
9632
by: Wayne Baswell | last post by:
I want to pass a date variable to a sql statement from Crystal Reports. The part of the query accepting the variables looks like: "Calendar_Date between To_Date('1-JUN-03','mm/dd/yy') and To_Date('30-JUN-03','mm/dd/yy')" And I'd be wanting to replace the date part of the query with a user-entered date. As I'm new to Oracle and Crystal, I don't know where to start. Is there a way to replace the '1-JUN-03' part with a variable in...
2
437
by: Asfand Yar Qazi | last post by:
Ahem.. Anyway, here's whats happening... construct tables in MySQL: DROP TABLE EMP; CREATE TABLE EMP (EMPNO INT(4) NOT NULL, ENAME CHAR(6) NOT NULL,
1
17327
by: Raghu | last post by:
Hello... I am running into a problem while running a query..can some1 help.. this is the query : ************** SELECT * from Table S where S.dtDate1 BETWEEN dateadd(year,1,dateadd(month,-1,getdate())) AND dateadd(day,-1,(dateadd(month,1,dateadd(year,1,dateadd(month,-1,getdate()))))) *************** (first part of the date calculation comes out to be '2005-05-01' and
2
39059
by: zdk | last post by:
I have table name "actionlog",and one field in there is "date_time" date_time (Type:datetime) example value : 11/1/2006 11:05:07 if I'd like to query date between 24/07/2006 to 26/07/2006(I don't need time),how to write SQL command? select * from actionlog where date_time 24/07/2006 AND date_time < 24/07/2006 ??
3
4352
by: RLN | last post by:
Re: Access 2003/Oracle 9i I have an Access app that connects to an Oracle DB via OLEDB/VBA code (no DSN or ODBC) Queries against straight Oracle tables run fine. For this query, however, the condition for finding DeptID's in the Oracle table have to be filtered by a list of DeptID's found in "tblDeptID" which is a simple local Access table containing one column
1
2770
by: mm27603 | last post by:
I'm trying to do a simple query of an Oracle 10g database within some vbscript code. <% 'Get protocol information to display in dropdown list %> <!--#include file="dbconnect2.inc"--> <% sql= "select DISTINCT PROTOCOLNAME FROM GPL_PPDB.VW_IVRS_INFO_2 WHERE SPONSORNAME = '" & Sponsor & "' ORDER BY PROTOCOLNAME ASC" Set RS = Conn.Execute(sql) %></span>
11
16326
by: funky | last post by:
hello, I've got a big problem ad i'm not able to resolve it. We have a server running oracle 10g version 10.1.0. We usually use access as front end and connect database tables for data extraction. We have been using oracle client 10.1.0.2 with it's odbc for a while without problem. The problem arose when we decided to reconnect all the tables and save password. Some query became suddenly very slow. Then I've discovered that the tables...
1
1673
by: laxmikumar999 | last post by:
Hi all, I have a data as given below. ID RATE1 DATE1 RATE2 DATE2 CODE 10 A 2007-FEB-01 U 2007-JAN-01 BIG 10 B 2007-FEB-01 V 2007-JAN-01 BIG 10 C 2007-JAN-01 W 2007-FEB-01 SMALL 10 D 2007-FEB-01 X 2007-JAN-01 SMALL
19
6019
by: phill86 | last post by:
Hi I am re-posting this thread because it has become very confusing and I have got some way to solving the problem so it is a slightly different question from the initial thread. here is the original tread http://bytes.com/topic/access/answers/872005-query-date-range Just to clarify what I am trying to achieve....
0
8704
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9187
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...
1
8936
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7776
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...
0
5879
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
4390
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
4636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3071
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
2
2360
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.