Hi,
This will display all records > the given date.
Let as assume i am giving the query as follows;
select * from jobs where datein >= '10-JUN-2003'
Then this will return all the jobs from 10th Jun 2003.
I want to list out all jobs in a particular day (with
different times).
--- Bartholomew Okonkwo <[Email Address Removed] ok are u running this from MSSQL Server. i tought u
> are running from oracle.
>
> am afraid trunc is not an MSSQL function.
>
> why not try
>
> select * from jobs where datein >= '16-JUN-2003'
> THIS WILL DISPLAY YOUR
> ROWS.
>
> HALLO ME BACK ON THE OUTCOME
>
> -----Original Message-----
> From: Bajal Mohamed [mailto:[Email Address Removed] Sent: Monday, June 16, 2003 10:51 AM
> To: Bartholomew Okonkwo; LazyDBA.com Discussion
> Subject: RE: Using "like" keyword to return date
> values ....
>
>
> Hi,
>
> I get the error like this;
>
> Server: Msg 195, Level 15, State 10, Line 1
> 'trunc' is not a recognized function name.
>
>
>
> --- Bartholomew Okonkwo <[Email Address Removed] wrote:
> > PLEASE TRY THIS QUERY
> >
> > select * from jobs where trunc(datein) >=
> > '16-JUN-2003'
> >
> > This will truncate the time stamp and display the
> 2
> > rows for you.
> >
> >
> > good luck mohamed
> >
> > barth
> > lagos Nigeria
> >
> > -----Original Message-----
> > From: Bajal Mohamed [mailto:[Email Address Removed] > Sent: Monday, June 16, 2003 10:41 AM
> > To: LazyDBA.com Discussion
> > Subject: Using "like" keyword to return date
> values
> > ....
> >
> >
> > Hi Gurus,
> >
> > I have a "datein" column in a table with datatype
> > Datetime, which stored jobs come in date and time.
> >
> > I want to list all jobs comes in a day. for this i
> > used the query given below;
> >
> > Select * from jobs where datein like '%6/16/2003%'
> >
> > But this query doesn't return any result though i
> > have
> > jobs comes in today.
> >
> > The datein values are stored as follows;
> >
> > 16-Jun-2003 14:30
> > 16-Jun-2003 16:11
> >
> > from these datas, this query should return 2 rows,
> > but
> > didn't.
> >
> > Advice please.
> >
> > Advanced thanks for your help.
> >
> >
> >
> > =====
> >
> > Best Regards,
> > Bajal Mohamed.
> >
> > Mobile : + 673 + 8611056
> >
> > Time and tide wait for none
> >
> >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> >
> >
>
---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> > JUST REPLY
> > To unsubscribe, e-mail:
> > mssqldba-[Email Address Removed] > For additional commands, e-mail:
> > mssqldba-[Email Address Removed] > The Information contained and transmitted by this
> > E-MAIL is proprietary to
> > Diamond Bank and/or its Customer and is intended
> for
> > use only by the
> > individual or entity to which it is addressed,
> and
> > may contain information
> > that is privileged, confidential or exempt from a
> > disclosure under
> > applicable law. If this is a forwarded message,
> the
> > content of this E-MAIL
> > may not have been sent with the authority of the
> > Bank. Diamond Bank shall
> > not be liable for any mails sent without due
> > authorisation or through
> > unauthorised access. If you are not the intended
> > recipient, an agent of the
> > intended recipient or a person responsible for
> > delivering the information to
> > the named recipient, you are notified that any
> use,
> > distribution,
> > transmission, printing, copying or dissemination
> of
> > this information in any
> > way or in any manner is strictly prohibited.
> > If you have received this communication in error,
> > please delete this mail
> > and notify us immediately at [Email Address Removed]
> >
> >
>
---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> > JUST REPLY
> > To unsubscribe, e-mail:
> > mssqldba-[Email Address Removed] > For additional commands, e-mail:
> > mssqldba-[Email Address Removed] >
>
>
> =====
>
> Best Regards,
> Bajal Mohamed.
>
> Mobile : + 673 + 8611056
>
> Time and tide wait for none
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> The Information contained and transmitted by this
> E-MAIL is proprietary to
> Diamond Bank and/or its Customer and is intended for
> use only by the
> individual or entity to which it is addressed, and
> may contain information
> that is privileged, confidential or exempt from a
> disclosure under
> applicable law. If this is a forwarded message, the
> content of this E-MAIL
> may not have been sent with the authority of the
> Bank. Diamond Bank shall
> not be liable for any mails sent without due
> authorisation or through
> unauthorised access. If you are not the intended
> recipient, an agent of the
> intended recipient or a person responsible for
> delivering the information to
> the named recipient, you are notified that any use,
> distribution,
> transmission, printing, copying or dissemination of
> this information in any
> way or in any manner is strictly prohibited.
> If you have received this communication in error,
> please delete this mail
> and notify us immediately at [Email Address Removed]
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
=====
Best Regards,
Bajal Mohamed.
Mobile : + 673 + 8611056
Time and tide wait for none
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
MS Sql Server LazyDBA home page