Skip Navigation Links
Novas Tecnologias
Ferramentas Adicionais
Ferramentas Adicionais


Dica No :
1125
Assunto : SQL Server
Titulo: Obtendo o primeiro dia do mês a partir de uma data

Gostou do texto ? Vote e dê sua opinião! Pontuação atual :

Translate this page now :






Adicione aos Favoritos!
BlogBlogs Rec6 Linkk Ueba Technorati Delicious DiggIt! StumbleUpon




Eventualmente, em cálculos, tendo uma data poderemos desejar obter o primeiro dia do mesmo mês.

Isso pode ser obtido com um cálculo simples :

DECLARE @DATA DATETIME
SET @DATA = GETDATE()
SELECT CONVERT(VARCHAR, @DATA - DAY(@DATA) + 1, 103) as PrimeiroDiaDoMes

Claro que pode ser reduzido a uma única linha se necessário :

SELECT CONVERT(VARCHAR, GETDATE() - DAY(GETDATE()) + 1, 103) as PrimeiroDiaDoMes


Nome :
E-mail:
Comentarios :
 
 
Os Últimos Comentários
data: 3/8/2021 12:57:00 PM
nome: pAlromVuxfMjPlGqk
email: abraham6j@usa.net
comentário:
I'm a trainee https://medwynsurgery.nhs.uk/?s=%20%E2%AD%90%20Approved%20USA%20Pharmacy%20Levitra%20%E2%AD%90%20WWW.PILLS2SALE.COM%20%E2%AD%90%20Buy%20Levitra%20Online%20Usa%20-%20Buy%20Levitra%20Usa buy levitra usa
RBC's Hutton pointed out that while the appointment of vanBeurden was a surprise, Shell had in the past named bosses fromthe downstream, or refining, part of the business includingVoser's predecessor Jeroen van der Veer.


data: 3/7/2021 2:18:00 AM
nome: pihGQaQXPWhHPIbds
email: jeromejqr@lycos.com
comentário:
Good crew it's cool :) http://dvd-shrink-software.de/provera-5-mg-precio-isseg-polq injeo depo provera generico Last month, New York's Department of Financial Services saidit had sent letters to 35 payday loan companies asking them tostop offering exploitative payday loans in New York via theInternet or by other means.

data: 3/7/2021 2:18:00 AM
nome: dJrHdTwoKLwwcy
email: christopher5q@lycos.com
comentário:
There's a three month trial period http://geodronsolutions.com/parlodel-2-5-mg-tabletten-ahdv parlodel medicamento generico Most opponents of the proposed U.S. military strike do not contest the administration's view that the Syrian government gassed its own people on August 21. Their expressed concerns focus instead on the effectiveness and potential unintended consequences of a U.S. military response.

data: 3/7/2021 2:18:00 AM
nome: uvwOSmVZWnJlLGiXWT
email: duncanefd@aol.com
comentário:
Which university are you at? https://cofradiasoledadcadiz.es/amitriptyline-goodrx-coupon-ahdv amitriptyline hcl 25 mg tab myl Franzen has many good points to make about the slavish way we volunteer our personal information to make money for big internet corporations, but as the rants intensify and the froth flies, he loses nuance, and with it sympathy. It’s hard not to roll eyes as he rages and makes dubious assumptions. And in some ways his approach is self-defeating: in trashing Twitter all he does is drive more traffic there.

data: 3/7/2021 2:18:00 AM
nome: qFIKPXOZlqxgxMst
email: heyjew@msn.com
comentário:
Best Site good looking http://www.implantstudygroup.com/kamagra-100mg-oral-jelly-ajanta-pharma-polq kamagra oral jelly 100mg cijena The dollar, nevertheless, barely reacted to data pointing toa healing labor market. The number of Americans filing newclaims for jobless benefits edged higher last week but remainedat pre-recession levels.

 1  
Dicas
Dica do Dia
Receba Dicas Por Email
E-mail :  
 


 (help)
Aceito receber informativos do devASPNet, informações de eventos e treinamentos

Veja Quais Informativos Você Receberá

Pesquisar Dicas
Pesquisar Artigos, Dicas e Noticias

Banco de Dados
Algumas Entrevistas
Links Importantes

Búfalo Informática, Treinamento e Consultoria
R. Alvaro Alvim, 37/920 Centro - Cinelândia - Rio de Janeiro Cep: 20031-010
Tel : (21) 2262-1368 (21) 9240-5134 E-mail : Contato@bufaloinfo.com.br