gastao Posted February 14, 2014 at 03:22 PM Report #545268 Posted February 14, 2014 at 03:22 PM tou a retornar um select onde a data vem no seguinte formato 14-02-2014 00:00:00 mas eu só quero que me fique como 14-02-2014 alguem me consegue dar essa dica... select campo1, campo2, campo3,campodata from tabela
nelsonr Posted February 14, 2014 at 04:32 PM Report #545287 Posted February 14, 2014 at 04:32 PM Boas, e isso é de que tipo de base de dados?
Hélder Posted February 24, 2014 at 09:20 PM Report #546531 Posted February 24, 2014 at 09:20 PM (edited) Viva, se no teu select usares um: CONVERT(SMALLDATETIME, @AtuaData, 105) não resolve o teu problema? Edited February 24, 2014 at 09:20 PM by Hélder
gastao Posted February 25, 2014 at 03:39 PM Author Report #546600 Posted February 25, 2014 at 03:39 PM resolvi de outra forma tks na mesma
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now