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] 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
MS Sql Server LazyDBA home page