{"id":2494,"date":"2017-08-21T15:44:19","date_gmt":"2017-08-21T15:44:19","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-obtenir-le-jour-de-la-semaine-a-partir-dune-date-dans-netsuite-sql\/"},"modified":"2026-07-28T18:26:01","modified_gmt":"2026-07-28T18:26:01","slug":"comment-obtenir-le-jour-de-la-semaine-a-partir-dune-date-dans-netsuite-sql","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-obtenir-le-jour-de-la-semaine-a-partir-dune-date-dans-netsuite-sql\/","title":{"rendered":"Comment obtenir le jour de la semaine \u00e0 partir d&rsquo;une date dans NetSuite SQL ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"D\u00e9couvrez la fonction SQL sp\u00e9cifique permettant de convertir un champ de date en son nom de jour de la semaine correspondant \u00e0 des fins de reporting.","ga_short_answer":"Pour r\u00e9cup\u00e9rer le nom complet du jour de la semaine \u00e0 partir d\u2019un champ de date dans NetSuite SQL, utilisez les fonctions TO_CHAR et TO_DATE. Cette combinaison permet de formater avec pr\u00e9cision les valeurs de date en leur repr\u00e9sentation textuelle du jour, ce qui est essentiel pour les rapports personnalis\u00e9s et les recherches enregistr\u00e9es n\u00e9cessitant des donn\u00e9es sp\u00e9cifiques \u00e0 un jour.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019afficher le jour de la semaine (par exemple, \u00ab lundi \u00bb, \u00ab mardi \u00bb) plut\u00f4t que la simple date dans <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-apply-date-range-filters-to-saved-searches-on-netsuite-dashboards\/\">les rapports personnalis\u00e9s ou les recherches enregistr\u00e9es de NetSuite<\/a>. L\u2019extraction directe de ces informations \u00e0 partir d\u2019un champ de date standard n\u00e9cessite une fonction SQL sp\u00e9cifique permettant de formater la valeur de la date en nom de jour sous forme textuelle.","ga_solution":"Pour obtenir le jour de la semaine \u00e0 partir d\u2019un champ de date, utilisez la fonction SQL suivante : `TO_CHAR(TO_DATE({date}),'DAY')`. Cette fonction convertit d'abord le champ de date en un type de donn\u00e9es \u00ab date \u00bb \u00e0 l'aide de `TO_DATE`, puis le formate pour obtenir le nom complet du jour \u00e0 l'aide de `TO_CHAR` avec le mod\u00e8le de format \u00ab DAY \u00bb. Remplacez `{date}` par l\u2019identifiant r\u00e9el du champ de date ou le nom de la colonne de votre ensemble de donn\u00e9es.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:44:19+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"SQL function to get Day of the week","ga_ans_id":"ANS-0018","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[90,90],"ga_difficulty":[93,93],"class_list":["post-2494","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-utilisateur-avance-de-netsuite","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":90,"label":"Utilisateur avanc\u00e9 de NetSuite"},{"value":90,"label":"Utilisateur avanc\u00e9 de NetSuite"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"},{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2494\/revisions"}],"predecessor-version":[{"id":2514,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2494\/revisions\/2514"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2494"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2494"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2494"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}