Oracl cmd for dayname

jullien88 Messages postés 2 Statut Membre -
krakixx Messages postés 3404 Date d'inscription Statut Membre Dernière intervention - 17 mars 2014 à 09:50

Hi,
my table contains a colun "datetime" (16/02/2013 , ....)
i would like to extract the dayname (saturday, ...)
can one of you help me .
thx.

Afficher la suite

A voir également:

Oracl cmd for dayname
Downloader for pc - Télécharger - Téléchargement & Transfert
Cmd - Guide
Scannow cmd - Guide
Copytrans heic for windows - Télécharger - Visionnage & Diaporama
Cmd winget upgrade - Guide

1 réponse

Réponse 1 / 1
krakixx Messages postés 3404 Date d'inscription Statut Membre Dernière intervention 721

to_char(to_date(03/09/1982,'dd/mm/yyyy'), 'DAY')

I think it should work

for first three characters

select to_char(to_date('03/09/1982','dd/mm/yyyy'), 'DY')

for only first letter capital

select to_char(to_date('03/09/1982','dd/mm/yyyy'), 'Dy')
1
1. jullien88 Messages postés 2 Statut Membre
  
  Hi
  Thx for your answer. The pb is resolved but i can't get what i want from my table.
  I want to get all the values of my table where datetime (one of my column ) is like 'sunday'.
  
  select * FROM my_table WHERE to_char(to_date(trunc(datetime),'dd/mm/yyyy'), 'DAY') like 'sunday'
  
  is there any solution ?
  
  0
2. krakixx Messages postés 3404 Date d'inscription Statut Membre Dernière intervention 721
  
  I would not answer my knowledge on Oracle are limited. And I think no one gives you the solution because it is a forum (French) so it does not speak English . I hope you have help.
  
  0

Oracl cmd for dayname

1 réponse

Discussions similaires

Newsletters