in access
Select * from Table where field between
cdate("01/12/2005") and cdate("31/12/2005")
in sql
Select * from Table where field between
converttodate("01/12/2005") and
converttodate("31/12/2005")
--- Alfonso Pérez Arrazubi <[EMAIL PROTECTED]>
wrote:
> Hi, I have a problem wiht a SQL Sentence, if I
> have got a field char(30) and this field of one
> table of my database have for example : "01/12/2005
> 10:12:25" my question is how can I do a selection if
> I want do a selection between 01/12/2005 to
> 31/12/2005 and show the result in a datagrid. I´m
> working with Sybase
>
> I have tried:
>
> Select * from Table where field
> between like "01/12/2005%" and
>
> like "31/12/2005%"
>
> Error
>
> If I try
>
> Select * from Table where field like
> "01/12/2005%"
>
> The result is ok.
>
> Any idea ?????? Any help ???? Any example ????
> Thanks in advance.
>
>
> "Willemse, K.F." <[EMAIL PROTECTED]>
> wrote: Can't you simply write one yourself? That
> should not be very hard for someone who has some
> experience in programming...
>
> -----------------------------
>
> I need a function which is writing price by text
> For example : 223 $ -> twohundredtwentytree dollars
>
> Where can I find ?
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> SPONSORED LINKS
> Basic programming language C programming
> language Computer programming languages
> Programming languages C programming language
> Software programming language
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "Microsofts_C_Sharp" on the
> web.
>
> To unsubscribe from this group, send an email
> to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
> ---------------------------------
>
>
>
>
>
>
> ---------------------------------
> Yahoo! for Good - Make a difference this year.
__________________________________
Yahoo! for Good - Make a difference this year.
http://brand.yahoo.com/cybergivingweek2005/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/XGgtlB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Microsofts_C_Sharp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
