Funciona sim... pode testar. Sds, Ricardo.
Ezequiel <[EMAIL PROTECTED]> escreveu: tente fazer assim: select extract (month from data) as mes from tabela nunca testei no IB6, mas deve funcionar. []'s Ezequiel Régis Bender escreveu: > > > Bom dia pessoal. > Alguem sabe me dizer qual comando SQL eu utilizo pra pegar apenas o mês > de um lançamento? > Utilizo Delphi 7 com IB 6.5 > > sds > > Bender Desenvolvimento de Sistemas > e Serviços Contábeis (Régis) > (51) 98470699 > > Novo Hamburgo/RS > MSN: [EMAIL PROTECTED] <mailto:regissk8%40terra.com.br> > > [As partes desta mensagem que não continham texto foram removidas] > > > Mensagens neste tópico > <http://br.groups.yahoo.com/group/delphi-br/message/171416;_ylc=X3oDMTM4ZGMzZ203BF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BG1zZ0lkAzE3MTQxNgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzExNzg2MjgxOTMEdHBjSWQDMTcxNDE2> > > (1) Responder (através da web) > <http://br.groups.yahoo.com/group/delphi-br/post;_ylc=X3oDMTJydWRuanQ3BF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BG1zZ0lkAzE3MTQxNgRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzExNzg2MjgxOTM-?act=reply&messageNum=171416> > > | Adicionar um novo tópico > <http://br.groups.yahoo.com/group/delphi-br/post;_ylc=X3oDMTJlZW9jMnRuBF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTE3ODYyODE5Mw--> > > > Mensagens > <http://br.groups.yahoo.com/group/delphi-br/messages;_ylc=X3oDMTJlZWZ2dTJiBF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BHNlYwNmdHIEc2xrA21zZ3MEc3RpbWUDMTE3ODYyODE5Mw--> > > | Arquivos > <http://br.groups.yahoo.com/group/delphi-br/files;_ylc=X3oDMTJmY2U2ZmplBF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BHNlYwNmdHIEc2xrA2ZpbGVzBHN0aW1lAzExNzg2MjgxOTM-> > > | Fotos > <http://br.groups.yahoo.com/group/delphi-br/photos;_ylc=X3oDMTJlbjFtODIyBF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BHNlYwNmdHIEc2xrA3Bob3QEc3RpbWUDMTE3ODYyODE5Mw--> > > | Links > <http://br.groups.yahoo.com/group/delphi-br/links;_ylc=X3oDMTJmdWdsNTgxBF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BHNlYwNmdHIEc2xrA2xpbmtzBHN0aW1lAzExNzg2MjgxOTM-> > > | Banco de dados > <http://br.groups.yahoo.com/group/delphi-br/database;_ylc=X3oDMTJjOWlsbnA5BF9TAzk3NDkwNDM3BGdycElkAzEwNTg3NzgEZ3Jwc3BJZAMyMTM3MTExMjY0BHNlYwNmdHIEc2xrA2RiBHN0aW1lAzExNzg2MjgxOTM-> > > __________________________________________________ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ [As partes desta mensagem que não continham texto foram removidas]